Rounding off to the nearset 0.05

  • Thread starter Thread starter Pheng
  • Start date Start date
P

Pheng

Hi all,

This may sound very simple, but how do you get a total, or cell t
round to the nearest 0.05.

For example:

2.44 = 2.45
2.43 = 2.40
2.46 = 2.50

Cheers
 
I'm not sure what you're criteria are for "nearest 0.05" given your
examples.

=ROUND(A1/0.05,0)*0.05

will round 2.43, 2.44 and 2.46 to 2.45

Assuming 2.45 should round to 2.45, you could for your examples use

=IF(MOD(A1,0.1)<=0.03, FLOOR(A1,0.05),CEILING(A1,0.05))
 
Back
Top