I am trying to calculate, using multiple nested "If" statements, a risk value ("high", "medium", or "low") that populates a 3x3 matrix. I want to construct arguments such that if a value in column 1 is a certain text value (e.g., text value "likely, "possible", or "unlikely")and a value in a second column is another text value (e.g., "minimal", "moderate", or "significant"), the formula returns the value "high", "medium", or "low" based on the intersction of the text values in the 3x3 matrix.
My attempt at nesting the If statements continously returns errors, and I note that the Excel Help file seem to have a limit of seven nested entries; I seem to need nine arguments? Can you offer a suggested solution? Thanks.
My attempt at nesting the If statements continously returns errors, and I note that the Excel Help file seem to have a limit of seven nested entries; I seem to need nine arguments? Can you offer a suggested solution? Thanks.