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
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
Would =ceiling(a1,10000) help?
perfect! thanks
No it isn't, CEILING rounds up, you said round, you need
=ROUND(A1,-4)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
