I have a List containing a Calculated Field, "Risk Priority", which is calculated using the formula:
=IF( ISBLANK([Internal Control Score])
,Impact*Probability
,Impact*Probability*[Internal Control Score]
)
So if no "Internal Control Score" has been entered, "Risk Priority" is the product of "Probability" * "Impact"; if an "Internal Control Score" has been entered, then the "Risk Priority" is reduced accordingly. So far, so straightforward.
However, there is now a business requirement to display the resulting "Risk Priority" as a text value - Low for Risk Priority scores of less than 4, Medium for values of 5 to 12, and High for values over 12. This is the bit I don't know how to do without adding an additional "Display Risk Priority" column to the list. I'd also like to avoid CSR or JSlink.