I have the following formula : =ROUND(D22/125*16,0)/16
How can I round this formula up?
Using =ROUND(D22/125*4,0)/4 has rounded to 1/4 in crements, but it rounds
down not up.

Thanks

Check out ROUNDUP()


--
Regards,
Dave


"Erik Millerd" wrote:

I have the following formula : =ROUND(D22/125*16,0)/16
How can I round this formula up?
Using =ROUND(D22/125*4,0)/4 has rounded to 1/4 in crements, but it rounds
down not up.

Thanks

On Wed, 28 Sep 2005 06:45:02 -0700, Erik Millerd
wrote:

I have the following formula : =ROUND(D22/125*16,0)/16
How can I round this formula up?
Using =ROUND(D22/125*4,0)/4 has rounded to 1/4 in crements, but it rounds
down not up.

Thanks

Your formula does arithmetic rounding: It will round up if the D22/125 is more
halfway or more between. Eg. 25.375 will round to 25 1/2 25.374 will round to
25 1/4.

If you always want to roundup to the next highest 1/4; merely substitute the
ROUNDUP function for the ROUND function in your formula.

=ROUNDUP(D22/125*4,0)/4


Or, a bit simpler if you are always dealing with positive numbers:

=CEILING(D22/125,0.25)



--ron