Dawn,

In that case use:

{ IF a1 "100""{ =(
round((((a1-100)/50)+(MOD(((a1-100)/50),1)0)/2),0)*b1)}""0"}

--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support

Dawn Rhoads wrote:
Wow, thanks! I can see it would have taken about an ice age for me
to figure this out on my own. The formula works perfectly as long as
I enter a total that is a multiple of 50. But something doesn't seem
to work quite right, I think it's the "round" feature. When I
entered 201 for the "total" and a rate of "200"I got a resulting
amount of $404. The answer I want it to give me is $400. 201-100/50
= 2.02. I need 2.02 to round up to 3 and then have 3 multiply by the
"rate". Any further ideas? Thanks so much for your help!

"Charles Kenyon" wrote:

{ IF { REF "Total" } 100 "{ = ROUND({ = { = { = { REF "Total"
}-100 } /50 } * { REF "Rate" } },0) }" "0" }

I think. I may have overdone it but it seems to work.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Dawn Rhoads" Dawn wrote in
message ...
I am trying to insert an if calculation into a Word table. It will
reference
two other fields in other locations in the table. One is a number
of pages
(let's call that "Total"). Another is a rate ("Rate"). We think
we have the
math figured out, but I don't have enough experience with IF and
calculation
fields to figure this out very easily.

We also think it will use the "round" function, which we think
means if a number in our calculation is a decimal, it will be
rounded up to the nearest
whole number.

IF the Total100, then round (Total-100)/50*Rate, ELSE 0.

Any thoughts would be greatly appreciated. Thanks!