Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested Ifs
Hi all,
I have used Chip Pearsons work around for nested ifs. I have named my 6 separate formulas All1 - All6. But the 'Master' formula does not seem to work. I am trying to do something like =IF(Data!A2=All1,All1,IF(Data!A2=All2,All2, etc. Any help greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested Ifs
How about
=IF(Data!A2=All1,All1,"")&IF(Data!A2=All2,All2, "")&etc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Amy" wrote in message ... Hi all, I have used Chip Pearsons work around for nested ifs. I have named my 6 separate formulas All1 - All6. But the 'Master' formula does not seem to work. I am trying to do something like =IF(Data!A2=All1,All1,IF(Data!A2=All2,All2, etc. Any help greatly appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested Ifs
What result does =All1 produce?
What result does =IF(Data!A2=All1,All1,"No Answer") produce? If these don't work as expected, then of course nesting more on to it won't either..... hth Vaya con Dios, Chuck, CABGx3 "Amy" wrote: Hi all, I have used Chip Pearsons work around for nested ifs. I have named my 6 separate formulas All1 - All6. But the 'Master' formula does not seem to work. I am trying to do something like =IF(Data!A2=All1,All1,IF(Data!A2=All2,All2, etc. Any help greatly appreciated. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested Ifs
=All1 produces a #NAME? error.
=IF(Data!A2=All1,All1,"No Answer") works fine as does each of my statements. What appears to happen however is that my IF statements work when I have an =IF(Data!A2="Apple","Apple") but in the cases where I have a =IF(Data!A2="Banana","Yellow") the statements aren't working and are appearing blank. Each individual statements works on its own but when I use them in the master statement, the yellows stop appearing whilst the apples do. My while statement looks like this: =IF(Data!O2=Part1,Part1,"")&IF(Data!O2=Part2,Part2 , "")&IF(Data!O2=Part3,Part3, "")&IF(Data!O2=Part4,Part4, "")&IF(Data!O2=Part5,Part5, "")&IF(Data!O2=Part6,Part6, "")&IF(Data!O2=Part7,Part7, "") The same applies when I try this one: =IF(Data!A2=All1,All1,IF(Data!A2=All2,All2,IF(Data !A2=All3,All3,IF(Data!A2=All4,All4,IF(Data!A2=All5 ,All5,IF(Data!A2=All6,All6,IF(Data!A2=All7,All7,"" ))))))) "CLR" wrote: What result does =All1 produce? What result does =IF(Data!A2=All1,All1,"No Answer") produce? If these don't work as expected, then of course nesting more on to it won't either..... hth Vaya con Dios, Chuck, CABGx3 "Amy" wrote: Hi all, I have used Chip Pearsons work around for nested ifs. I have named my 6 separate formulas All1 - All6. But the 'Master' formula does not seem to work. I am trying to do something like =IF(Data!A2=All1,All1,IF(Data!A2=All2,All2, etc. Any help greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested Sub-Totals in Excel | Excel Discussion (Misc queries) | |||
Nested IF statement with VLOOKUP | Excel Discussion (Misc queries) | |||
Nested Subtotals in Excel 2002 | Excel Discussion (Misc queries) | |||
Why are my nested sub-totals are displaying incorrectly? | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions |