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
http://www.wimgielis.be = Excel/VBA, soccer and music


"Astroboy" wrote:

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....!!!