Hi,
I need some help for a college project. I have searched Google for the past 30 minutes trying to find the answer, but it brings up formulas that don't help me.
Basically, I need a cell to change its name based on another cells value.
These are the words I need a cell to change to based on the value of another cell.
Poor between 0.01 and 4.00
Fair between 4.01 and 6.00
Good between 6.01 and 7.50
Very Good between 7.51 and 8.75
Excellent between 8.76 and 10.00
So, I need Cell F9 to change its name, for example to Fair, when I enter 4.50 into cell F8, however, if I then change the value in Cell F8 to 6.01, Cell F9 would need to automatically change to Good.
Any help would be greatly appreciated.
Thanks.
Bookmarks