I am trying to use a formula to multiply 2 columns together. The Values are text (critical, high,medium,low) and map to 4,3,2,1. I want to multiply High * High where that is 3*3.

I imagine that I could create additional columns to maybe map the values and do the math on those.

Any ideas would be useful. Thank you.