G Guest May 25, 2007 #1 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,
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,
N Niek Otten May 25, 2007 #2 It is not clear to me to nearest *what* you want to round -- Kind regards, Niek Otten Microsoft MVP - Excel | 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,
It is not clear to me to nearest *what* you want to round -- Kind regards, Niek Otten Microsoft MVP - Excel | 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,
S Stan Brown May 26, 2007 #3 Fri, 25 May 2007 11:52:02 -0700 from <=?Utf-8?B?VG9ueSBLYXk=?= <Tony (e-mail address removed)>>: 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, Click to expand... 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.
Fri, 25 May 2007 11:52:02 -0700 from <=?Utf-8?B?VG9ueSBLYXk=?= <Tony (e-mail address removed)>>: 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, Click to expand... 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.
G Guest May 29, 2007 #4 Hi Tony, =FLOOR(C3, .025) =CEILING(C3,.05) Let me know if this helps. Thanks, Peggy
