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

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,

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

It is not clear to me to nearest *what* you want to round

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Tony Kay" <Tony wrote in message ...
| 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,

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/

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

Hi Tony,

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

Let me know if this helps.

Thanks,
Peggy


"Tony Kay" wrote:

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,