rounding to nearest 100
=ROUND(A1,0)
"rdwngr23" wrote:
is there a way to have a cell round to the nearest 100 up and or down?
if i have 4.595 i would like it to round up to 5 but if i change it 4.493 i
would like it to round down to 4.
looking for a formula that would work for both in one cell
|