View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SimonCC
 
Posts: n/a
Default 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?