How can I make a cell to afect another?



There’s a way to put a value in one column and depending on the number, it automatically choose one of pre existent values in another? That way:

I’ll have a column named “Grade” and another named “Rating”. In the column grade, I’ll put numbers from 0 to 100, and in Rating, I’ll use “Awesome, Great, Good, Bad, Awful and Why God?”. And I want one of the Rating itens to be auto added depending on the number I use in the Grade Column.

Awesome to 95+
Great to 80 ~ 94
Good to 60 ~ 79
Bad to 40 ~ 59
Awful to 20 ~ 39
Why God to 0 ~ 19

Is that possible?