Thread
:
I need a formula with rounding up & rounding down to the nearest .
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Stan Brown
external usenet poster
Posts: 524
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/
Reply With Quote
Stan Brown
View Public Profile
Find all posts by Stan Brown