Thread: Rounding up or down to nearest whole number
View Single Post
  #2  
Old November 18th, 2009, 03:08 PM posted to microsoft.public.excel.misc
Tom Hutchins
external usenet poster
  
Posts: 722
Default Rounding up or down to nearest whole number
Try

=ROUND(D$32*B33,0)

Hope this helps,

Hutch

"KC" wrote:

What formula would I use to round a number to a whole number, ie 2.4 would
round to 2, 2.55 would round to 3. I'm tried using the following formula,
however it only rounds up.

=CEILING(D$32*B33,1)