Thread: Round up numbers to either a half or a whole depending on which side of 0.5 it is
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Williams John Williams is offline
external usenet poster
  
Posts: 1
Default Round up numbers to either a half or a whole depending on which side of 0.5 it is
Hi

Is there any way in Excel 2002 to do the above.

E.g.

My vertical sum comes to 15.2 so I want that changed to 15.5
or
My vertical sum comes to 15.6 so I want that changed to 16

It doesn't matter if the rounding takes place in a different cell to the
sum.

TIA

John


Reply With QuoteReply With Quote