MrExcel Publishing
Your One Stop for Excel Tips & Solutions

any way to round to the nearest .95?


Posted by Kevin on June 15, 2001 7:59 AM

Is there any way in Excel to automatically round a given number upwards to the nearest .95? For example, if the result of a formula in a cell was 8.50, I would want the resulting number in the cell to round up to 8.95. Any way to do this? Thanks a million

kevin


Posted by Barrie Davidson on June 15, 2001 8:20 AM

How about =INT("your formula")+0.95

Barrie

Posted by IML on June 15, 2001 8:28 AM

There is probably a better way, if your number is cell A1 the following should work for postive numbers.

=IF(A1-INT(A1)=0.95,A1,IF(A1-INT(A1)>0.95,INT(A1)+1.95,INT(A1)+0.95))

Posted by IML on June 15, 2001 8:40 AM

I'll theive from Barry to improve mine a little: (still only good for positives)

=IF(A1-INT(A1)<=0.95,INT(A1)+0.95,INT(A1)+1.95)