Fx If.....Question from Super Newbie...

[Astroboy]

Hi,

First want to say thanks to those who help me with previous questions.. that
helps me a lot.... Thank You!!!!

Here are another problem I am having difficult to solve... yup.. I am super
newbie...

Okay here are my problem...


B23-- can have either "on" or "off"


S1, S2, S3, S4, S5, S6 --- these cels can have either "yes" or "no"


In cel A10:

-----If B23 have "on" then check (Except S4)
--------------S1 and if yes then show "apple"
--------------S2 and if yes then show "boat"
--------------S3 and if yes then show "cup"
--------------S5 and if yes then show "pen"
--------------S6 and if yes then show "snoopy"
-------------- nothing is yes then show "neither"

-----If B23 have "off" then check (Except S6)
--------------S1 and if yes then show "apple"
--------------S2 and if yes then show "boat"
--------------S3 and if yes then show "cup"
--------------S4 and if yes then show "chuck"
--------------S5 and if yes then show "pen"
-------------- nothing is yes then show "neither"


Any Idea....

Thank you Everyone....!!!

 

[Wigi]

Hi

=IF(B23="on",IF(S1="yes","apple",IF(S2="yes","boat",IF(S3="yes","cup",IF(S5="yes","pen",IF(S6="yes","snoopy",""))))),IF(S1="yes","apple",IF(S2="yes","boat",IF(S3="yes","cup",IF(S4="yes","chuck",IF(S5="yes","pen",""))))))

 

[Wigi]

A bit shorter:

=IF(S1="yes","apple",IF(S2="yes","boat",IF(S3="yes","cup",IF(B23="on",IF(S5="yes","pen",IF(S6="yes","snoopy","")),IF(S4="yes","chuck",IF(S5="yes","pen",""))))))

 

[ShaneDevenshire]

Hi,

1. Create the following table in some blank area of your spreadsheet:

no apple apple
no boat boat
no cup cup
Yes chuck
no pen pen
no snoopy
Yes neither neither

2. In my example the range was D1:F7.
3. In cell D1 enter =S1
4. Copy this formula down to D6. Leave Yes in D7.

In A10 enter the following formula:

=VLOOKUP("yes",D1:F7,IF(B23="on",2,3),FALSE)

If this helps, please click the Yes button.