Go to Tools--Addins and turn on the Analysis Toolpak (if it's not already).
Then use the MROUND function, thusly:
=MROUND(A1,100)
Hope it helps!
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"Julie P." wrote in message
...
Hi, I am looking for a formula that will round any amount over a multiple
of
$100 to the next $100. So, for example,
Input -- Output
$0 -- $0
$1 -- $100
$50 -- $100
$100 -- $100
$169 -- $200
$200 -- $200
$201 -- $300
etc.
Is there such a formula, and would it involve ROUND, since this is not
really rounding?
Also, can anyone tell me what the syntax of the ROUND formula is?
=ROUND(?,?)
I want to know so I will be able to compute this for myself in the future.
And is there a list of all known Excel formulae?
Thanks!
Julie