Head Gone to Mush with an IF formula
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
"Sean" wrote in message
...
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,"")," "))
|