Rounding

Posted by heavington on November 02, 2000 9:30 AM

This is probably an easy task for some of you, but I am having a heck of a time with it. I have a column of different prices, and I want to round them up to the nearest .09, example:
3.25 to 3.29
4.57 to 4.59
2.20 to 2.29

You get the idea. Is there a simple task for this that will round them in next column? Thanks in advance for your help.
Heavington

Posted by Neil on November 02, 2000 11:01 AM

If you are always rounding up try

=(INT(A1*10+1)*10-1)/100

You could also probably use variations of ROUND, ROUNDUP or MROUND

Posted by Celia on November 02, 2000 3:14 PM

Here's one alternative :-

=ROUNDDOWN(A1,1)+0.09

Celia