More Help Needed!

S

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!
 
D

David Biddulph

In general one could probably get away with
=-AND(AH2,B2)
but the formulae can behave rather differently if input cells are empty.
 
Top