Display message based on multiple criteria..

I have created a sheet that calculates a score. Based on that score a determination is made to do one of three things - Nothing, Peer/Manager Review, Review Required.
In addition it was requested now that I make an overall decision for "Review Required" based on multiple triggers. My thought was to create a table from outputs of each element on another sheet, and then trigger off the table. What I am stuck on is using the multiple choices to trigger the message - Below are the choices of which each or a combination of each should trigger "Review Required"
Calculate Review Required

Total Score 'Review Required
Element 1 "
Element 2 "
Element 3 "
Element 4 "
Element 5 "
Element 6 "
Element 7 "
Element 8 "
Element 9 "
Element 10 "
Element 11 "
Element 12 "
Element 13 "
Element 14 '20 or more = reveiw
Element 15 '20 or more = reveiw
Element 16 '20 or more =review
Element 17 'Sum 20 Total of above if less than 20 in each

If I understand correctly you want the additional decision "Review Required" if:
1. Element 14, 15 or 16 has a score of >=20
2. The total score >=20 while individual scores <20

Assuming scores are in column A1 - A18 (A18 being total sum) you could use:

Formula:

Please Login or Register  to view this content.

yes - I will adapt your formula for the Element 14 - 17.
I also have to have the save 'review required' triggered based on any of the elements 1-13. I originally only had to do it on a score....which I was successful at using a similar IF statement.
Now there are multiple criteria that create the same "review required' ...its got me stumped

Yes, adapting for additional arguments will do the job for you. I'm not sure there's added value in using a table, though you could split out the whole IF formula into smaller IF formula's using VLOOKUP.

E.g. in a new column you VLOOKUP the elemnt name in a table, and compare to the score in that table,:

Formula:

Please Login or Register  to view this content.

Sum up all individual comparissons and if at least one formula evaluates to 1, your sum >0 so you need to review.

Good luck and let me know if it worked out for you

Ahhh...its very close but I get either #Ref or #Name in the formula.
I forgot to mention in my energetic state to finish this. I had set each row for the entire column using formulas for each cell so that "Yes" is displayed when the correct condition for that cell exists that would trigger "Review Required" The False statement would be "Peer/Manager" on sheet CPLX. There are two sheets. The visible/data entry sheet known as CPLX, and the sheet I hide where calculation takes place known as Param. The outputs for the elements above are in sheet Param!G42:G60

I built a sheet in which I hope to clarify what I am trying to accomplish. The sheet the user sees is Calc. The working sheet is Param. I am trying to display one of two available messages based on either total score or any of the additional elements causing the sheet to diaplay "Review Required" I have come close but cant seem to get the last step and I am convinced is something simple