Thread: Rounding Up
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Rounding Up

Quotient ignores any decimal remainder.

Try this:

=CEILING(31200/102,1)

--
Biff
Microsoft Excel MVP


"Renee" wrote in message
...
How do i set my calculator to round up, because it is not rounding up
decimal
place values. I have Qoutient (31200,102) the answer gives 305 but it
should
say 306