Hello all,
This one should be easy, yet for some reason I get the feeling I'm overthinking it and would love to get your thoughts. Here is what I'm trying to accomplish.
On the attached spreadsheet, I would like the answer in B11 to inform the cell C11. However, I’m trying to write ranges that satisfy the legend d8 through d11. If the answer is >20, I want Critical to auto populate. If the answer is >14 I want Moderate, and if the answer is 15< I want Low.
By chance the above is not clear perhaps this might help. The range is 21+ = Critical, 20 to 15 is Moderate, and 14 and lower is Low.
Thanks,
Dave
This one should be easy, yet for some reason I get the feeling I'm overthinking it and would love to get your thoughts. Here is what I'm trying to accomplish.
On the attached spreadsheet, I would like the answer in B11 to inform the cell C11. However, I’m trying to write ranges that satisfy the legend d8 through d11. If the answer is >20, I want Critical to auto populate. If the answer is >14 I want Moderate, and if the answer is 15< I want Low.
By chance the above is not clear perhaps this might help. The range is 21+ = Critical, 20 to 15 is Moderate, and 14 and lower is Low.
Thanks,
Dave
