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 |
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) |