Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fx If.....Question from Super Newbie...
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....!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fx If.....Question from Super Newbie...
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....!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fx If.....Question from Super Newbie...
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 ","")))))) -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Wigi" wrote: 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....!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fx If.....Question from Super Newbie...
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. -- Thanks, Shane Devenshire "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....!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie Question... | New Users to Excel | |||
Newbie question | Charts and Charting in Excel | |||
Real Newbie newbie question | New Users to Excel | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Newbie question | New Users to Excel |