Thread: How to round the numeric value?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
ozgrid.com ozgrid.com is offline
external usenet poster
  
Posts: 464
Default How to round the numeric value?
=CEILING(A1,0.5)


--
Regards
Dave Hawley
www.ozgrid.com
"Salman Saeed" <Salman wrote in message
...
Kindly tell me that how can we round the numeric value?
Example: 1.2 = 1.5, 1.7 = 2.0

Reply With QuoteReply With Quote