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
|