Having problems with formula nested tables in Excel

[Chad]

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

 

[Elkar]

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]

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]

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]

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]

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]

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