View Single Post
  #3  
Old April 26th, 2010, 11:49 AM posted to microsoft.public.excel.newusers
ozgrid.com
external usenet poster
 
Posts: 328
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