Est. Budget: $25.00
We require the formula to be written to populate a calculated field in sharepoint.
There are 2 fields each with 5 options and 4 possible outcomes for each of the combinations as per the attached spreadsheet.
Therefore we require the IF, OR, AND equation to provide the correct outcomes for the 25 combinations.
Please see attached Risk Matrix.
The outcome should be a single line of formula that can be entered into calculated value field on the column set up ...