Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a calculation setup in a column with no decimal points (whole
numbers only). The calculation results in the number being rounded up. I would like the number to be round down to the whole digit number (ie if the result is 23.78, I would like it round down to 23). Below is a example of the current formula: =SUM((220-F2)*0.9) What do I have to add to this calculation to get it to round down. Thanks Charlie ************************************************** **** Charliec |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - Calculation Problems | Excel Discussion (Misc queries) | |||
Excel 2007 calculation bug fix | Excel Discussion (Misc queries) | |||
Excel 2007 calculation bug fix | New Users to Excel | |||
Excel 2007 calculation bug fix | Excel Worksheet Functions | |||
rounddown | Excel Worksheet Functions |