Example 1.xlsx
I'm trying to build a QC checklist that scores each correct or incorrect line item.
I can get a coulple of criteria covered, but I can't get it to look for a value in all three columns and return the score i need based on the box checked. Each line item should only have one item selected and some line items may carry more weight than others.
Looking to return a value of 0 if B3=x, C3= "", N3=""
Looking to return a value of 5 if B3="", C3="x", N3=""
Looking to return a value of 0 if B3="", C3= "", N3="x"
In some instances an "x" in c may only be worth 1.
Please see my attachment and let me know if you have any questions.
Thank you in advance for the help
Bookmarks