| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Having problems with formula nested tables in Excel
I have the follwing formula in a cell.
=IF(U18,(IF(U20,(IF(U22,"STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Training Needs Tab","Proceed in Answering questions 1 through 28")))),"") When I hit return it does not show the words but only False or nothing. What am I doing wrong. I am using three true false statements that say. cell U18 =IF(AND(S18,T20,T22),TRUE, FALSE) cell U20 =IF(AND(S20,T22,T18),TRUE, FALSE) cell u22 =IF(AND(T18,T20,S22),TRUE, FALSE) can anyone help me please Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Having problems with formula nested tables in Excel
The way it is written, you will only get words if everything is TRUE or if
everything but U22 is TRUE. Perhaps you could rewrite as: =IF(AND(U18,U20,U22),"STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Training Needs Tab","Proceed in Answering questions 1 through 28") HTH Elkar "Chad" wrote: I have the follwing formula in a cell. =IF(U18,(IF(U20,(IF(U22,"STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Training Needs Tab","Proceed in Answering questions 1 through 28")))),"") When I hit return it does not show the words but only False or nothing. What am I doing wrong. I am using three true false statements that say. cell U18 =IF(AND(S18,T20,T22),TRUE, FALSE) cell U20 =IF(AND(S20,T22,T18),TRUE, FALSE) cell u22 =IF(AND(T18,T20,S22),TRUE, FALSE) can anyone help me please Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Having problems with formula nested tables in Excel
NOw I am getting the words but only "Proceed in Anwsering Questions 1 through
2. change the "and" to an "Or" I only get the "STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Do I have too many true false statments? Help. Thanks Chad "Elkar" wrote: The way it is written, you will only get words if everything is TRUE or if everything but U22 is TRUE. Perhaps you could rewrite as: =IF(AND(U18,U20,U22),"STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Training Needs Tab","Proceed in Answering questions 1 through 28") HTH Elkar "Chad" wrote: I have the follwing formula in a cell. =IF(U18,(IF(U20,(IF(U22,"STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Training Needs Tab","Proceed in Answering questions 1 through 28")))),"") When I hit return it does not show the words but only False or nothing. What am I doing wrong. I am using three true false statements that say. cell U18 =IF(AND(S18,T20,T22),TRUE, FALSE) cell U20 =IF(AND(S20,T22,T18),TRUE, FALSE) cell u22 =IF(AND(T18,T20,S22),TRUE, FALSE) can anyone help me please Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Having problems with formula nested tables in Excel
Look at your results in U18, U20, and U22. Do they all say TRUE? Then you
should be getting the "STOP..." text displayed. If any one of them is FALSE, then you should get the "Proceed..." text displayed. I don't think you have too many TRUE/FALSE statements, but you may need to go back to each one individually to make sure it is in fact returning the appropriate response. HTH Elkar "Chad" wrote: NOw I am getting the words but only "Proceed in Anwsering Questions 1 through 2. change the "and" to an "Or" I only get the "STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Do I have too many true false statments? Help. Thanks Chad "Elkar" wrote: The way it is written, you will only get words if everything is TRUE or if everything but U22 is TRUE. Perhaps you could rewrite as: =IF(AND(U18,U20,U22),"STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Training Needs Tab","Proceed in Answering questions 1 through 28") HTH Elkar "Chad" wrote: I have the follwing formula in a cell. =IF(U18,(IF(U20,(IF(U22,"STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Training Needs Tab","Proceed in Answering questions 1 through 28")))),"") When I hit return it does not show the words but only False or nothing. What am I doing wrong. I am using three true false statements that say. cell U18 =IF(AND(S18,T20,T22),TRUE, FALSE) cell U20 =IF(AND(S20,T22,T18),TRUE, FALSE) cell u22 =IF(AND(T18,T20,S22),TRUE, FALSE) can anyone help me please Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Having problems with formula nested tables in Excel
None of them will say true at the same time. These are the option results
in U18, U20 and U22. true, false, false or False, True, False or False, False True. Did I use a wrong formula? Thanks for the help "Elkar" wrote: Look at your results in U18, U20, and U22. Do they all say TRUE? Then you should be getting the "STOP..." text displayed. If any one of them is FALSE, then you should get the "Proceed..." text displayed. I don't think you have too many TRUE/FALSE statements, but you may need to go back to each one individually to make sure it is in fact returning the appropriate response. HTH Elkar "Chad" wrote: NOw I am getting the words but only "Proceed in Anwsering Questions 1 through 2. change the "and" to an "Or" I only get the "STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Do I have too many true false statments? Help. Thanks Chad "Elkar" wrote: The way it is written, you will only get words if everything is TRUE or if everything but U22 is TRUE. Perhaps you could rewrite as: =IF(AND(U18,U20,U22),"STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Training Needs Tab","Proceed in Answering questions 1 through 28") HTH Elkar "Chad" wrote: I have the follwing formula in a cell. =IF(U18,(IF(U20,(IF(U22,"STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Training Needs Tab","Proceed in Answering questions 1 through 28")))),"") When I hit return it does not show the words but only False or nothing. What am I doing wrong. I am using three true false statements that say. cell U18 =IF(AND(S18,T20,T22),TRUE, FALSE) cell U20 =IF(AND(S20,T22,T18),TRUE, FALSE) cell u22 =IF(AND(T18,T20,S22),TRUE, FALSE) can anyone help me please Thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Having problems with formula nested tables in Excel
Ok, I misunderstood what you were trying to do then. Perhaps if we back up
and just describe under what conditions should the "STOP..." message be displayed? Under what conditions should the "Proceed" message be displayed? Are there times when neither should be displayed? "Chad" wrote: None of them will say true at the same time. These are the option results in U18, U20 and U22. true, false, false or False, True, False or False, False True. Did I use a wrong formula? Thanks for the help "Elkar" wrote: Look at your results in U18, U20, and U22. Do they all say TRUE? Then you should be getting the "STOP..." text displayed. If any one of them is FALSE, then you should get the "Proceed..." text displayed. I don't think you have too many TRUE/FALSE statements, but you may need to go back to each one individually to make sure it is in fact returning the appropriate response. HTH Elkar "Chad" wrote: NOw I am getting the words but only "Proceed in Anwsering Questions 1 through 2. change the "and" to an "Or" I only get the "STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Do I have too many true false statments? Help. Thanks Chad "Elkar" wrote: The way it is written, you will only get words if everything is TRUE or if everything but U22 is TRUE. Perhaps you could rewrite as: =IF(AND(U18,U20,U22),"STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Training Needs Tab","Proceed in Answering questions 1 through 28") HTH Elkar "Chad" wrote: I have the follwing formula in a cell. =IF(U18,(IF(U20,(IF(U22,"STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Training Needs Tab","Proceed in Answering questions 1 through 28")))),"") When I hit return it does not show the words but only False or nothing. What am I doing wrong. I am using three true false statements that say. cell U18 =IF(AND(S18,T20,T22),TRUE, FALSE) cell U20 =IF(AND(S20,T22,T18),TRUE, FALSE) cell u22 =IF(AND(T18,T20,S22),TRUE, FALSE) can anyone help me please Thanks |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Having problems with formula nested tables in Excel
I have three questions in excel. Each question has a yes no answer.
Question 1 and Question two if checked "yes" will result in the word saying below "Stop,......" the third question if you check "yes" I want a result of word saying "Proceed" see below Ye No Do you spend 100% of your work hours in the office FALSE FALSE FALSE Do you spend some of your work hours in a office or visiting clients in their offices FALSE FALSE FALSE Do you spend the majority of your time in the field where you will be exposed to construction related activities. Construction activities includebut not limited to the follwing: heavy equipment, scaffolds, excavations, use fall protection, traffic, aerial lift etc. TRUE FALSE FALSE Proceed in Answering questions 1 through 28 I hope I explained this better. Thanks Chad "Elkar" wrote: Ok, I misunderstood what you were trying to do then. Perhaps if we back up and just describe under what conditions should the "STOP..." message be displayed? Under what conditions should the "Proceed" message be displayed? Are there times when neither should be displayed? "Chad" wrote: None of them will say true at the same time. These are the option results in U18, U20 and U22. true, false, false or False, True, False or False, False True. Did I use a wrong formula? Thanks for the help "Elkar" wrote: Look at your results in U18, U20, and U22. Do they all say TRUE? Then you should be getting the "STOP..." text displayed. If any one of them is FALSE, then you should get the "Proceed..." text displayed. I don't think you have too many TRUE/FALSE statements, but you may need to go back to each one individually to make sure it is in fact returning the appropriate response. HTH Elkar "Chad" wrote: NOw I am getting the words but only "Proceed in Anwsering Questions 1 through 2. change the "and" to an "Or" I only get the "STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Do I have too many true false statments? Help. Thanks Chad "Elkar" wrote: The way it is written, you will only get words if everything is TRUE or if everything but U22 is TRUE. Perhaps you could rewrite as: =IF(AND(U18,U20,U22),"STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Training Needs Tab","Proceed in Answering questions 1 through 28") HTH Elkar "Chad" wrote: I have the follwing formula in a cell. =IF(U18,(IF(U20,(IF(U22,"STOP You have completed the Training Needs Assessment. Please have your supervisor review your training needs on the Employee Training Needs Tab","Proceed in Answering questions 1 through 28")))),"") When I hit return it does not show the words but only False or nothing. What am I doing wrong. I am using three true false statements that say. cell U18 =IF(AND(S18,T20,T22),TRUE, FALSE) cell U20 =IF(AND(S20,T22,T18),TRUE, FALSE) cell u22 =IF(AND(T18,T20,S22),TRUE, FALSE) can anyone help me please Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I am having problems with a IF(AND(OR nested function | Excel Worksheet Functions | |||
| Is anyone having problems with nested subtotaling in XP Excel | Excel Discussion (Misc queries) | |||
| Nested If problems | Excel Worksheet Functions | |||
| Problems printing a word document with linked excel tables. | Excel Discussion (Misc queries) | |||
| Is there some way to pivot nested tables or subtable in excel | Excel Discussion (Misc queries) | |||
Linear Mode
