Rounding - for retail prices

M

May W.

I am trying to round a set of numbers to "5's and 9's". For example if a
price is $1.44, I would like to to round to $1.45. Or, if a price is $1.88 I
would like it to round to 1.89.

Thank you!
 
A

anilsolipuram

try this

=(INT(E23*10)/10)+(IF(MOD(E23*10,1)*10>5,9,IF(MOD(E23*10,1)=0,0,5))/100
 
Top