Hi, I am working on a report and need some assistance. I am working with Windows XP Professional and Excel 2007.
My report is looking for a formula that will reflect if the goal is in jeopardy of being missed.
If cell A2 = "COMP" the result should be "NO"
If cell A2 = "PENDING" and cell B2 is any number between 0 thru 9 the result should be "PENDING"
If cell A2 = "PENDING" and cell B2 is any number between 10 thru 15 the result should be "YES"
If cell A2 = "PENDING" and cell B2 is greater or equal to 16 the result should be "FAIL"
Any help would be GREATLY appreciated!!
My report is looking for a formula that will reflect if the goal is in jeopardy of being missed.
If cell A2 = "COMP" the result should be "NO"
If cell A2 = "PENDING" and cell B2 is any number between 0 thru 9 the result should be "PENDING"
If cell A2 = "PENDING" and cell B2 is any number between 10 thru 15 the result should be "YES"
If cell A2 = "PENDING" and cell B2 is greater or equal to 16 the result should be "FAIL"
Any help would be GREATLY appreciated!!
