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)
