[Stacy Birk]

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

[macropod[_2_]]

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

[Stacy Birk]

Thank You, macropod!

And especially for the 'note' part.

I have done the following:

Opened Document
Unprotected Document
Clicked Table, Insert Formula
In Formula Field typed "=MAX({=D19*D21},150)" (without the quotation
marks)
In the Format Field, selected "$#,##0.00;($#,##0.00)" (without the
quotation marks)
Clicked Ok

Received: "!Syntax Error, {" (without the quotation marks)

I gave elementary steps I know, please know I am not questioning your
intelligence but more so questioning my own with this process. Would
you mind correcting me on where I went wrong?

I greatly appreciate your help, macropod.

Stacy


On Aug 25, 7:47*pm, "macropod" wrote:
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 ...

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...bles/browse_th...

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

[Stacy Birk]

I should have specified that I did try to do this as well:

Go to the cell within the table.
CTRL-F9=max(CTRL F9=D19*D21 ,150)

And that did not work either. I am sorry for the double post, I
should have stated that as well.

[macropod[_2_]]

Hi Stacy,

Where you want the calculation to go, press Ctrl-F9 twice, so that you get a nested pair of field braces, thus '{ { } }'. Then
fillin/around them so that you end up with '{=MAX({=D19*D21},150)}'

--
Cheers
macropod
[Microsoft MVP - Word]


"Stacy Birk" wrote in message ...
I should have specified that I did try to do this as well:

Go to the cell within the table.
CTRL-F9=max(CTRL F9=D19*D21 ,150)

And that did not work either. I am sorry for the double post, I
should have stated that as well.

[Stacy Birk]

Thank you for sticking with me, macropod.

I did as you suggested and wrote (CTRL-F9 Twice for { } ): {=MAX
({=D19*D21},150)}

I received this: !Syntax Error, $

When I right clicked for field code, this appears: {=MAX
($374,696,150)}

When I ALT-F9 I see the code that I typed: {=MAX({=D19*D21},150)}

I double checked the table cell references, those are correct. Your
thoughts?