Head Gone to Mush with an IF formula

[Sean]

Could I ask for help, as my brains turned to mush and I'm cross eyed
looking at this simple IF formula. What I wish to express is:

IF Z33=0, then
IF Sum(N7171)=0, then
IF Y33=FALSE

Then return value in A71, otherwise
<blank>

My umteenth attempt is below, but it returns "FALSE"

=IF(Z33=0,IF(SUM(N7171)=0,IF(Y33=FALSE,A71,""),""))

 

[Max]

IF Y33=FALSE

What's the formula in Y33?

 

[Sean]

Y33=FALSE

 

[Sean]

Max a better representation might be:

Z22=0
Sum(N6060)=0
Y22=TRUE

So I expect my answer to return "", it displays as FALSE

 

[Max]

One guess, try:
=IF(Z33=0,IF(SUM(N7171)=0,IF(Y33="FALSE",A71,""),""))
The above presumes that you're checking Y33 for the text: FALSE

 

[Sean]

But if Y33=TRUE, it doesn't return a <blank>, which I'm looking for

 

[Max]

But it does return blank for me, see this test file:
http://www.freefilehosting.net/download/3chka

 

[David Biddulph]

You haven't defined the answer for when Z33 is not zero, so in that case it
would return FALSE.
You could try either
=IF(Z33=0,IF(SUM(N7171)=0,IF(Y33=FALSE,A71,""),""),"") or
=IF(AND(Z33=0,SUM(N7171)=0,Y33=FALSE),A71,"")

 

[Sean]

You haven't defined the answer for when Z33 is not zero, so in that case it
would return FALSE.
You could try either
 =IF(Z33=0,IF(SUM(N7171)=0,IF(Y33=FALSE,A71,""),""),"") or
 =IF(AND(Z33=0,SUM(N7171)=0,Y33=FALSE),A71,"")
--
David Biddulph










- Show quoted text -

Thanks, its pretty simple but I just couldn't see it