How can I round up a fraction?

[Guest]

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

 

[Guest]

Check out ROUNDUP()

 

[Ron Rosenfeld]

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