Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a User Form using an If statement field code | Mailmerge | |||
How do you add an IF statement to a user form field? | Microsoft Word Help | |||
Form field in conditional statement | Microsoft Word Help | |||
Calculate date with form field | Microsoft Word Help | |||
form field auto calculate | Microsoft Word Help |