View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default HOW DO I ROUNDUP A RESULT OF A FORMULA TO NEAREST WHOLE NUMBER

=ceiling(C18/15,1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"onsitegirl" wrote in message
...
for example, my formula in the cell is =(c18/15)
if the result of the formula is 60.2, the cell displays 60 but i want it

to
round UP to the nearest whole number. do i have to add to that formula

the
end result?