| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to round down the result of a formula
i am trying to get excel to round down (instead of round up) the result of
the following formula: =IF((100-(((I2)-0.75)*144))100,100,(100-(((I2)-0.75)*144))). the input in I2 is 21:24, which is in the [h]:mm format. The answer is 79.6, but excel will by default display 80. I have noted the =ROUNDDOWN function, but i do not know if it can be applied within another formula. If so, then how? If not, then how can i get the result to round down? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get formula result of 3.56 to round up to 4 automatic? | Excel Worksheet Functions | |||
| How do I get formula result of 3.56 to round up to 4 automatic? | Excel Worksheet Functions | |||
| how do I round up a result of a formula in Excel | Excel Worksheet Functions | |||
| How to round up the result in a cell containing formula | Excel Worksheet Functions | |||
| How do I round up the result of a sum | Excel Worksheet Functions | |||
Threaded Mode
