Thread: How do I apply a rounding rule
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
riffmastr7 riffmastr7 is offline
external usenet poster
  
Posts: 6
Default How do I apply a rounding rule

Hi, I need to apply the rounding rule below for conducting our business when
dealing with a number that has a 0.5 ending:

Example:
If the average is 54.5, I need excel to round it to 54.
If the average is 55.5, I need excel to round it to 56.

Please help! Thanks.
Reply With QuoteReply With Quote