More Help Needed!

[sferguson]

Okay - now I have a formula that looks like this:

=IF(AH2=FALSE,0,-1)

This is working fine, but now I need it to do more. What I'm trying to do
is look at AH2 and if it says FALSE still return the 0 and if it says TRUE
return a -1 UNLESS cell B2 has a 0 in it - if cell B2 has a 0 in it and AH2
says TRUE, then I need it to return a 0.

Anyone have any ideas? Thanks for your help!

 

[Kevin B]

Try using the following formula:
=IF(AH2=FALSE,0,IF(AND(AH2=TRUE,B2=0),0,-1))

 

[sferguson]

That worked. Thanks so much!

Try using the following formula:
=IF(AH2=FALSE,0,IF(AND(AH2=TRUE,B2=0),0,-1))