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

Head Gone to Mush with an IF formula
 

IF Y33=FALSE

What's the formula in Y33?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Head Gone to Mush with an IF formula
 

Y33=FALSE

Head Gone to Mush with an IF formula
 

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

Head Gone to Mush with an IF formula
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sean" wrote in message
...
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

Head Gone to Mush with an IF formula
 

But if Y33=TRUE, it doesn't return a <blank, which I'm looking for

Head Gone to Mush with an IF formula
 

But it does return blank for me, see this test file:
http://www.freefilehosting.net/download/3chka

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sean" wrote in message
...
But if Y33=TRUE, it doesn't return a <blank, which I'm looking for

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

Head Gone to Mush with an IF formula
 

On Feb 26, 9:04*am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
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,"")," "))- Hide quoted text -

- Show quoted text -

Thanks, its pretty simple but I just couldn't see it

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