Formula Help

swaldon2

I am making a risk matrix and I want to be able to calculate the risk score. How can I get this formula to work? I have 5 columns, with the last column being the risk score. I cant get the formula to work and I think it is because of the other formulas in the helper column. If there is a way to achieve this please let me know!

[Helper] Likelihood formula: =IF([Likelihood (1-5)]@row = "1 - Very Low", "1", IF([Likelihood (1-5)]@row = "2 - Low", "2", IF([Likelihood (1-5)]@row = "3 - Medium", "3", IF([Likelihood (1-5)]@row = "4 - High", "4", IF([Likelihood (1-5)]@row = "5 - Very High", "5", "")))))

[Helper] Impact formula: =IF([Impact (1-5)]@row = "1 - Minor [Minimal impact on objectives]", "1", IF([Impact (1-5)]@row = "2 - Low [Slight delays or minor cost increases]", "2", IF([Impact (1-5)]@row = "3 - Moderate [Noticeable delays or moderate cost increases]", "3", IF([Impact (1-5)]@row = "4 - High [Significant impact on schedule or budget]", "4", IF([Impact (1-5)]@row = "5 - Critical [Severe impact; may jeopardize project success]", "5", "")))))

Risk Score: =[\[HELPER\] Likelihood]@row * [\[HELPER\] Impact]@row