I have a series of 5 cells, each populated with numbers ranging from 0 to 200. I'd like for a 6th cell to be automatically populated with a phrase based on the following criteria:
3 or more cells with 95 or better = "Tier 1"
2 cells with 95 or better = "Tier 2"
1 cell with 95 or better = "Tier 3"
0 cells with 95 or better = "Tier 4"
Any ideas? Thanks in advance for your time and your input : )
Jamie
3 or more cells with 95 or better = "Tier 1"
2 cells with 95 or better = "Tier 2"
1 cell with 95 or better = "Tier 3"
0 cells with 95 or better = "Tier 4"
Any ideas? Thanks in advance for your time and your input : )
Jamie