I need a formula with rounding up & rounding down to the nearest .

[Guest]

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,

 

[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,

 

[Stan Brown]

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,

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.

 

[Guest]

Hi Tony,

=FLOOR(C3, .025)
=CEILING(C3,.05)

Let me know if this helps.

Thanks,
Peggy