Thanks Bob,

User tried it, and it works!

Diane

"Bob Phillips" wrote:

Round to the nearest 100 is

=ROUND(x,-2)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Peo Sjoblom" wrote in message
...
50000? Since you say round up to nearest 100 if over 50 shouldn't 1234
round
up to 1300? Or did you mean 50000?

Regardsless round to nearest 100 is ROUND(x,100) round up is
CEILING(x,100)

so you can set it the way you want by testing the condition

=IF(x50,formula1,formula2

Regards,

Peo Sjoblom
"Diane" wrote in message
...
User wants to round up to nearest $100 dollar figure if it's over 50, or
down
to nearest $100 figure if it's under 50. For example, if they enter
dollar
figure of $1234.00, they want it rounded down to the nearest $100 dollar
amount, which would be $1,200.00. Thanks.