To Round upClick on your open box in Column A (the column you want to be rounding up)
Type,
=ROUNDUP(Click on the number you want to round up. (will show as D2, or F3, etc)
Type,
,-3)Hit EnterIt should look something like this...
=ROUNDUP(D2,-3)To Round down
Type,
=ROUNDDOWN(Click on your open box in Column B this time(the column you want to be rounding down)
Click on the number you want to round down. (will show as D2, F3, etc)
Type,
,-3)Hit EnterIt should look something like this...
=ROUNDDOWN(D2,-3)The number
-3 is designated for how many spaces LEFT of the decimal point you want to round towards Zero. So if you wanted to round the next space you would put -4, or if you wanted only 2 spaces LEFT of the decimal point, you would put -2. See?
That should work for you, it works for me.
Let me know how things go.
Edited by Ferrari, 29 March 2009 - 11:08 PM.