View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default How to round the numeric value?

Mon, 26 Apr 2010 02:59:01 -0700 from ?B?U2FsbWFuIFNhZWVk?= <=?
Utf-8?B?U2FsbWFuIFNhZWVk?=:

Kindly tell me that how can we round the numeric value?
Example: 1.2 = 1.5, 1.7 = 2.0


I don't know what that is, but it's not rounding. If you're rounding
to the nearest whole, 1.2 would round to .0 not 1.5. Even if you are
rounding to the nearest half, 1.7 would round to 1.5.

Instead of just giving examples, please state your what you're
actually trying to accomplish.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...