Forum Discussion
Formula for Multiple Outcomes
I am looking to create a formula between two cells that can have a variety of combinations. I would want the third column to populate with one of the three options (Exceeding, Delivering, Missing). D...
=IF(AND(A1="Exceeding",B1="Exceeding"),"Exceeding",
IF(AND(A1="Delivering",B1="Exceeding"),"Delivering",
IF(AND(A1="Delivering",B1="Delivering"),"Delivering",
IF(AND(A1="Delivering",B1="Missing"),"Missing",
IF(AND(A1="Missing",B1="Missing"),"Missing",
IF(AND(A1="Missing",B1="Missing"),"Missing",""))))))
You can use a nested IF formula. With recent versions of Excel you can use IFS as well.