Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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/ |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding up to nearest 500 | Excel Discussion (Misc queries) | |||
Rounding to the nearest 9th | Excel Discussion (Misc queries) | |||
Formula for rounding number to nearest hundred? | Excel Discussion (Misc queries) | |||
Formula for rounding number to nearest hundred? | Excel Discussion (Misc queries) | |||
What is the formula for rounding a dollar amount to the nearest ni | New Users to Excel |