View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default I need a formula with rounding up & rounding down to the nearest .

Fri, 25 May 2007 11:52:02 -0700 from <?B?VG9ueSBLYXk=?= <Tony
:
Ex. if my results in C3 = 6.630 then it should round down to 6.625 or if the
results = 6.720 should round up to 6.750,


Those examples are inconsistent with each other.

In your first example, the rounding is to the nearest 0.025 or less;
in the second example it is to the nearest 0.050 or more.

Please decide what you want to round to -- nearest 0.025, nearest
0.050, other. Then use the MROUND function to do your rounding.

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