Good morning,
I am trying to create a formula in an Excel sheet that will apply different criteria based on the client profile selected in cell D4 and the score at
I34.
The sheet has several tabs with the same risk rating (low, medium, and high) but different risk scores.
The current formula is designed for Profile A, but I need to modify it so that if Profile B is selected in D4, the risk rating in cell I35 and the recommended action in cell I39 will automatically change according to the parameters of Profile B tab
Moreover, if the selected profile is B, I need to apply a discount of -5 points.
I'm attaching the spreadsheet for reference.
I appreciate any help you can provide.
Best,
Andry
Bookmarks