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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
|
|