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!

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


"sferguson" wrote:

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!

That worked. Thanks so much!

"Kevin B" wrote:

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


"sferguson" wrote:

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!

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

"Kevin B" wrote in message
...
Try using the following formula:
=IF(AH2=FALSE,0,IF(AND(AH2=TRUE,B2=0),0,-1))
--
Kevin Backmann


"sferguson" wrote:

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!