Rounding - for retail prices

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
try this

=(INT(E23*10)/10)+(IF(MOD(E23*10,1)*10>5,9,IF(MOD(E23*10,1)=0,0,5))/100
 
You must log in or register to reply here.

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

Average If 3
Round values to 0.05 or 0.00 3
Need formula to round number up to always end in X.X9 6
Cost to Retail Price Formula - some help pse 2
Round up or down to $X.X9 or up to $X.X5 10
Pricing formula 5
Round Function 5
IF and Round 5

Back
Top