Hi Stacy ,
In Excel, you could do also use:
=MAX(D19*D21,150)
In Word, you could use a formula field (rather than a calculation formfield) coded as:
{=MAX({=D19*D21},150)}
Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.
--
Cheers
macropod
[Microsoft MVP - Word]
"Stacy Birk" wrote in message ...
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