Thread: Rounding Up or down to 1/2 Units
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default Rounding Up or down to 1/2 Units
On Fri, 06 Jan 2006 20:47:57 GMT, "Mal" wrote:

Hi People,
Is there a way to round up or down in 1/2 units.
e.g. 2.3 up to 2.5, 2.1 down to 2.
Any help appreciated.
Thanks,
Mal


=ROUND(A1*2,0)/2


--ron
Reply With QuoteReply With Quote