Thread: How can I round to a 0 or 0.5 in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default How can I round to a 0 or 0.5 in Excel?
One way:

=ROUND(23.2,0)

In article ,
Rose wrote:

For examples:

I want 23.20 to be 23.00
and
I want 23.6 to be 24.00

Reply With QuoteReply With Quote