I need a 0 and not True or False

[Syd]

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,

 

[Frank Kabel]

Hi
try
=IF(Results!$C$12>=1440,IF(BN11="X",TRUE,FALSE),FALSE)

 

[Frank Kabel]

Hi
sorry, misread your question. Try
=IF(Results!$C$12>=1440,IF(BN11="X",Results!$C$12,0),0)

 

[Tushar Mehta]

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