View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default Head Gone to Mush with an IF formula

Your formula will return FALSE if Z33 is not 0. Try

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

Tyro

"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,"")," "))