Rounding

D

DollarBill

I'm trying to round to the nearest nickel.

I have looked at the round function but can't seem to get it to work.

E.g. If it's .38, the display is .40. If it's 1.32, it's 1.30.

Thanks,
Bill
 
R

Ron Rosenfeld

I'm trying to round to the nearest nickel.

I have looked at the round function but can't seem to get it to work.

E.g. If it's .38, the display is .40. If it's 1.32, it's 1.30.

Thanks,
Bill
Click to expand...

=ROUND(A1/0.05,0)*0.05

--ron
 
Top