# Combining Formulas to make one big Formula

Options

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")

Tags:

• ✭✭✭✭✭✭
Options

=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", 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", 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", "")))))))))