View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
 
Posts: 454
Default Head Gone to Mush with an IF formula

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