ExcelBanter - how do you nest ROUNDDOWN in an IF formula?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do you nest ROUNDDOWN in an IF formula? (https://www.excelbanter.com/excel-worksheet-functions/93846-how-do-you-nest-rounddown-if-formula.html)

numbersguy

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?

SimonCC

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?

All times are GMT +1. The time now is 05:12 AM.