Nested if....?

[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




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Tom Ogilvy]

=Trim(if(B1,A1,"") & " " & if(B2,A2,"") & " " & if(B3,A3,"") & " " &
if(B4,A4,""))