| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding Cell Values
How can a cell value be rounded down to the nearest even number
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding Cell Values
Hi,
Try =MROUND(A1-1,2) -- If this helps, please click the Yes button Cheers, Shane Devenshire "RWAMSLEY" wrote: How can a cell value be rounded down to the nearest even number |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding Cell Values
Try this
=FLOOR(A2,2) Mike "RWAMSLEY" wrote: How can a cell value be rounded down to the nearest even number |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding Cell Values
On Mon, 5 Jan 2009 11:17:01 -0800, RWAMSLEY
wrote: How can a cell value be rounded down to the nearest even number If the cell value is always positive, try the following =FLOOR(A1,2) If the cell value is always negative, try the following =-CEILING(-A1,2) If the cell value can positive or negative, try the following =CHOOSE(SIGN(A1)+2,-CEILING(-A1,2),0,FLOOR(A1,2)) Hope this helps / Lars-Åke |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding Time values | Excel Discussion (Misc queries) | |||
| Rounding up values | Excel Worksheet Functions | |||
| SUMPRODUCT rounding up values | Excel Worksheet Functions | |||
| rounding values in in array before sum | Excel Worksheet Functions | |||
| Stop rounding values | Excel Worksheet Functions | |||
Linear Mode
