Forum Discussion
Solved
IF Function
I'm trying to figure out what the function or formula might be if I wanted a cell to display a letter if an adjacent cell displayed a certain number. For instance, I'm a teacher and I want a column ...
Hi, You could nest IF formulas:
=IF(A2<69.5,"D",IF(A2<79.5,"C",IF(A2<89.5,"B","A")))
(I am assuming anything less than the range for C is a D and anything above the range for B is A in the Example above.
Hi, You could nest IF formulas:
=IF(A2<69.5,"D",IF(A2<79.5,"C",IF(A2<89.5,"B","A")))
(I am assuming anything less than the range for C is a D and anything above the range for B is A in the Example above.