| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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,"")," ")) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Head Gone to Mush with an IF formula
Y33=FALSE
|
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Head Gone to Mush with an IF formula
But if Y33=TRUE, it doesn't return a <blank, which I'm looking for
|
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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,"")," ")) |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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,"")," ")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Head to head | Excel Discussion (Misc queries) | |||
| Formula. Way over my head | Excel Discussion (Misc queries) | |||
| Simple If formula but can't get my head around it! | Excel Worksheet Functions | |||
| Cant get my head around this one | Excel Worksheet Functions | |||
| Over my head on this one... | Excel Worksheet Functions | |||
Linear Mode
