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


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

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


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.


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)