Good Morning,
Hope all is well with everyone. I am stuck and going round in circles using if statements and hope you can help me. i was wondering if they is another alternative? Or a completely different approach?
I have a grading table that has some numbers in, this is based on criteria in columns H and I,
Basically i would be putting in scores in row 9 through columns B/C/D/E/F
A11 is a cell that i would like to automatically populate showing Excellent / Good / Fair / Needs Improvement / Unsatisfactory / Fail based on what scores i put in.
If each column if blank = Blank
If the score in each column is zero the cell populates "Excellent"
Business Critical Column (B9) is 1 or more than 1 the cell in All populates "Fail"
Critical Column (C9) is 1-3 = "Unsatisfactory"
Critical Column (C9) is 4 or more than 4 = "Fail"
Major Column (D9) is 1-3 = "Needs Improvement"
Major Column (D9) is 4 or more than 4 = "Unsatisfactory"
Minor Column (E9) is 1 or more than 1 = "Fair"
Observation Column (F9) is 1 or more than 1 = "Good"
I hope this makes sense. Please find attached a spreadsheet. Thank you for taking your time and effort into looking into this. It is appreciated.
Bookmarks