ExcelBanter - Rounding - for retail prices

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rounding - for retail prices (https://www.excelbanter.com/excel-worksheet-functions/6176-rounding-retail-prices.html)

May W.

Rounding - for retail prices

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!

anilsolipuram

try this

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

--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=277249

All times are GMT +1. The time now is 05:42 AM.