Hi guys,
Thanks in advance for the help. I have attached an image below to explain better my request.
Immagine.png
The sum of those values (weighted) in TABLE 2 (see image above) will give me a total percentage (cell G16).
Now, I want a formula in TABLE 1, ROW 7 (Criteria 3), that will assign an "x" depending on the total percentage of CELL G16, TABLE 2.
So, if cell G16 is between 91% and 100% I want an "x" in cell B7, if it's between 81% and 90% I want an "x" in cell C7, and so on. If it's lower than 60% then no "x" will be assigned.
Is that possible to do? I hope I explained well enough...
Thanks!!
Bill
Bookmarks