T
Tony Kay
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,
results = 6.720 should round up to 6.750,
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
I need a formula with rounding up & rounding down to the nearest .
N
Niek Otten
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,
--
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
Fri, 25 May 2007 11:52:02 -0700 from <=?Utf-8?B?VG9ueSBLYXk=?= <Tony
[email protected]>>:
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.
[email protected]>>:
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.
P
pshepard
Hi Tony,
=FLOOR(C3, .025)
=CEILING(C3,.05)
Let me know if this helps.
Thanks,
Peggy
=FLOOR(C3, .025)
=CEILING(C3,.05)
Let me know if this helps.
Thanks,
Peggy