Nested Ifs

[Amy]

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.

 

[Bob Phillips]

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)

 

[CLR]

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]

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