I currently have all the individuals formulas i'm looking for however I'm having trouble combining them into one formula that I can embed in a cell. I know I can create a workflow automation to get the result I want however I enjoy the rapidness of using an embedded formula. Does anyone know if it's possible to combine the below formulas into work big formula that I can embed in a cell?
Where Priority is High
=IF(AND(Impact@row = "Critical", Likelihood@row = "Certain"), "High")
=IF(AND(Impact@row = "Significant", Likelihood@row = "Certain"), "High")
=IF(AND(Impact@row = "Critical", Likelihood@row = "Possible"), "High")
Where Priority is Medium
=IF(AND(Impact@row = "Critical", Likelihood@row = "Unlikely"), "Medium")
=IF(AND(Impact@row = "Significant", Likelihood@row = "Possible"), "Medium")
=IF(AND(Impact@row = "Minor", Likelihood@row = "Certain"), "Medium")
Where Priority is Low
=IF(AND(Impact@row = "Minor", Likelihood@row = "Possible"), "Low")
=IF(AND(Impact@row = "Significant", Likelihood@row = "Unlikely"), "Low")
=IF(AND(Impact@row = "Minor", Likelihood@row = "Unlikely"), "Low")
