A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Word 2003 - IF Statement, Form Field Calculate



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old August 25th, 2009, 10:19 PM posted to microsoft.public.word.tables
Stacy Birk
external usenet poster
 
Posts: 9
Default Word 2003 - IF Statement, Form Field Calculate

Greetings,

I have a table in Word 2003 and would like to do an “IF” statement on
a Text Form Field, type - Calculation.

The problem is: If CellA multiplied by CellB is $150 or less, the
answer is $150; otherwise the answer is the result of CellA multiplied
by CellB.

The expression would be this in Excel 2003: =IF(SUM(D19*D21)
150,150,SUM(D19*D21))

The expression would be this in Word 2003: *stumped*

I do not have the luxury of keeping Excel 2003 in the picture for this
document.

I have done Google searches for “IF” statements, formulas,
calculations, etc. And all “IF” calculations for Word 2003 lead me
to:

http://groups.google.com/group/micro...a67d4b94ada58f

AND

http://www.wopr.com/cgi-bin/w3t/show...?Number=365442

Anyone looking for a great tutorial should download MVP Macropods.
This person has amazing talent, simply an incredible tutorial . The
thoroughness of the project is remarkable.

Even though I found great resources and fantastic advice, I still come
up short on a valid Form Field Expression for this problem.

I have an example Word.doc if that would help, I do not mind emailing
it if that would be more helpful. Any help solving this dilemma is
greatly appreciated.

Stacy
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.