[Jay Freedman]

You're welcome.

By the way, it occurred to me as I reread my reply that there's a simpler
formula you could use:

{=MAX( {=H9*15%}, 1500)}

This one only calculates the 15% once, and then uses the larger of that
number or 1500.

Thomas wrote:
Jay:

Thank you so much, this is exactly what I was looking for. It works
great! I was on your site today looking for this, but was not able to
figure it out. Thank you very much.

"Jay Freedman" wrote:

Thomas wrote:
I have a small table with 4 or 5 fields that calculate based on the
first fields value. However, I need one field to calculate based on
an IF function.

I know how to write it in excel:
=IF(SUM(H9*15%)1500,SUM(H9*15%),1500)

but how do I write something like this in Word? I need to write a
formula that can calculate 15% of the value in cell D1. If it is
greater that 1,500, place the calculated value in this field, if it
is not greater than 1,500, place 1,500 in this field.

Please Help

Using Ctrl+F9 to insert each matched pair of field braces, use this
syntax:

{IF {=(H9*15%)} 1500 {=(H9*15%)} 1500}

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.