PDA

View Full Version : need help with rounding formula



HCI
06-04-2010, 09:50 AM
what formula do i use if i have a number over a million dollars and i want to round to the nearest ten thousand?

$1,257,342.56

to

$1,260,000.00

thanks in adavance

arthurbr
06-04-2010, 10:07 AM
Would =ceiling(a1,10000) help?

HCI
06-04-2010, 10:21 AM
perfect! thanks

Bob Phillips
06-04-2010, 11:36 AM
No it isn't, CEILING rounds up, you said round, you need

=ROUND(A1,-4)