Nested if....?

  • Thread starter Thread starter Darin Kramer
  • Start date Start date
D

Darin Kramer

Howdie...

Scenario...

cell A1 = Cats
A2 = Dogs
A3 = Mice
A4 = Bunnys

Depending on what a user chooses via a checkbox, the formulae will
append a True or False to cell B1 to B4...

So if user ticks Cats and Mice then b1 = True and B3 = True (b2 and b4
will be false)

My question is how do I see the result of the choice in another cell
(say A6).... so I want to see Cats and Mice as the answer in cell A6 in
this instance.

Obviously needs to change depending on what the user selects... he may
select one option, or all four....

Thanks

D
 
In A6 put the formula:

=SUBSTITUTE(IF(B1," AND "&A1,"")&IF(B2," AND "&A2,"")&IF(B3," AND
"&A3,"")&IF(B4," AND "&A4,"")," AND ","",1)

The SUBSTITUTE takes off the first occurrence of " AND " since you cannot
tell in advance which of your "animals" will be first.
 
Back
Top