Nov 11 2021 08:42 AM
Nov 11 2021 09:44 AM - edited Nov 11 2021 09:46 AM
Solution
Here's a different solution, one using tables and VLOOKUP. When you write a nested IF statement, it could work with these variables, but you would not have the flexibility that this gives you.
With a table, you have the option to change the words, the cutoffs--in short--to refine the conditions and the resulting priority setting. When you hardcode that into a formula, it becomes harder to maintain.
For help in understanding VLOOKUP, let me refer you to this resource: https://exceljet.net/excel-functions/excel-vlookup-function
By the way, in the future, since you already had created a spreadsheet in order to post an image of it, it would be far more helpful to those on this site if you posted that spreadsheet itself. As it is, I had to create it from your image.....
Nov 11 2021 09:56 AM
Nov 11 2021 10:24 AM
Nov 11 2021 09:44 AM - edited Nov 11 2021 09:46 AM
Solution
Here's a different solution, one using tables and VLOOKUP. When you write a nested IF statement, it could work with these variables, but you would not have the flexibility that this gives you.
With a table, you have the option to change the words, the cutoffs--in short--to refine the conditions and the resulting priority setting. When you hardcode that into a formula, it becomes harder to maintain.
For help in understanding VLOOKUP, let me refer you to this resource: https://exceljet.net/excel-functions/excel-vlookup-function
By the way, in the future, since you already had created a spreadsheet in order to post an image of it, it would be far more helpful to those on this site if you posted that spreadsheet itself. As it is, I had to create it from your image.....