Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested if....?
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested if....?
=Trim(if(B1,A1,"") & " " & if(B2,A2,"") & " " & if(B3,A3,"") & " " &
if(B4,A4,"")) -- Regards, Tom Ogilvy "Darin Kramer" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to add to nested IF | Excel Worksheet Functions | |||
nested if | Excel Discussion (Misc queries) | |||
Nested IF | Excel Worksheet Functions | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
What is quicker? Nested or non nested ifs | Excel Programming |