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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding a number up to a certain ending digit 6
Average If 3
Round up or down to $X.X9 or up to $X.X5 10
IF and Round 5
Round Function 5
Rounding Time to Nearest 5 Minutes 1
Pricing formula 5
Formula help 2

Top