how do you nest ROUNDDOWN in an IF formula?

numbersguy · Jun 14, 2006

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 · Jun 14, 2006

How about from
=IF(condition,result)
to
=IF(condition,ROUNDDOWN(result,0))

-Simon

how do you nest ROUNDDOWN in an IF formula?

numbersguy

SimonCC