Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.tables
Stacy Birk Stacy Birk is offline
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

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing a User Form using an If statement field code Brenda A. Reid[_2_] Mailmerge 2 August 13th 09 04:13 AM
How do you add an IF statement to a user form field? Larry Root Microsoft Word Help 3 July 2nd 09 01:58 PM
Form field in conditional statement [email protected] Microsoft Word Help 4 April 28th 09 06:17 AM
Calculate date with form field Mrs Dumm Microsoft Word Help 2 March 6th 08 11:28 PM
form field auto calculate JSwa Microsoft Word Help 2 February 13th 06 05:43 PM


All times are GMT +1. The time now is 08:09 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"