I HAVE THE FOLLOWING VARIABLES THAT SHOULD RESULT IN EITHER A COLUMN Y (CELL Y2) ANSWER OR A COLUMN P (CELL P2) ANSWER OR A COLUMN S (CELL S2) ANSWER. I2 needs to use: If E2 is <=72 and M2 is 0-2% then answer is Y2, IF E2is <=72 and M2 is >2% then the answer is P2, IF E2 is 73-84 and M2 is 0-1.5% then answer is Y2, IF E2 is 73-84 and M2 is >1.5% then the answer is S2 HERE'S WHAT I TRIED TO FORMULATE USING "IF" and "AND" FORMULAS. IF E2 <=72 + M2 0-2% = Y2 AND IF E2 <=72 + M2 >2% = P2 AND IF E2 = 73-84 + M2 0-1.5% = Y2 AND IF E2 = 73-84 + M2 >1.5% = S2 CAN YOU FIND A FORMULA THAT RESULTS IN AN ANSWER THAT SATISFIES ALL THE CONDITIONS?
Solved by A. S. in 27 mins