View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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,"")," "))