View Single Post
  #1   Report Post  
Erik Millerd
 
Posts: n/a
Default How can I round up a fraction?

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