Head Gone to Mush with an IF formula

  • Thread starter Thread starter Sean
  • Start date Start date
S

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(N71:P71)=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(N71:P71)=0,IF(Y33=FALSE,A71,""),""))
 
Max a better representation might be:

Z22=0
Sum(N60:P60)=0
Y22=TRUE

So I expect my answer to return "", it displays as FALSE
 
One guess, try:
=IF(Z33=0,IF(SUM(N71:P71)=0,IF(Y33="FALSE",A71,""),""))
The above presumes that you're checking Y33 for the text: FALSE
 
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(N71:P71)=0,IF(Y33=FALSE,A71,""),""),"") or
=IF(AND(Z33=0,SUM(N71:P71)=0,Y33=FALSE),A71,"")
 
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(N71:P71)=0,IF(Y33=FALSE,A71,""),""),"") or
 =IF(AND(Z33=0,SUM(N71:P71)=0,Y33=FALSE),A71,"")
--
David Biddulph










- Show quoted text -
Click to expand...

Thanks, its pretty simple but I just couldn't see it
 
Your formula will return FALSE if Z33 is not 0. Try

=IF(Z33=0,IF(SUM(N71:P71)=0,IF(Y33=FALSE,A71,""),""),"")

Tyro
 
Back
Top