Is it possible to write a calculation formula that isn't based on numbers?
Is it possible to write a calculation formula that isn't based on numbers? I am creating a risk assessment worksheet. There are 2 categories to score-severity and probability. The available options for severity are I, II, III, IV, and N/A. The available options for probability are A, B, C, D, and N/A. Depending on the combination of the 2 options (i.e. I-A, IV-C, etc), the result could be EH, H, M, or L. Is there a way to calculate the result based on the 2 inputs? I hope that makes sense.
