| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you nest ROUNDDOWN in an IF formula?
i am trying to round down the "true" result of an IF formula but can't figure
out how to nest the ROUNDDOWN formula within the IF formula.....can anyone help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you nest ROUNDDOWN in an IF formula?
How about from
=IF(condition,result) to =IF(condition,ROUNDDOWN(result,0)) -Simon "numbersguy" wrote: i am trying to round down the "true" result of an IF formula but can't figure out how to nest the ROUNDDOWN formula within the IF formula.....can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking portions of a formula | Excel Worksheet Functions | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| Nest a referenced formula in excel | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| How do you nest the following formula to show blank cells | Excel Worksheet Functions | |||
Linear Mode
