I need a 0 and not True or False

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The formula below works fine. Now I need it to generate a 0 instead of a true or False. I know it's possible, but forgot how. Can some one out there assist

=IF(Results!$C$12>=1440,IF(BN11="X",Results!$C$12)

Thanks,
 
Hi
sorry, misread your question. Try
=IF(Results!$C$12>=1440,IF(BN11="X",Results!$C$12,0),0)
 
Untested alternatives to Frank's suggestion:

=N(IF(Results!$C$12>=1440,IF(BN11="X",Results!$C$12)))

=IF(AND(Results!$C$12>=1440,BN11="X"),Results!$C$12,0)

or

=N((Results!$C$12>=1440)*(BN11="X")*Results!$C$12)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Business solutions leveraging technology
Microsoft Most Valuable Professional (MVP) 2000-2004
 
Back
Top