• 412K Members
• 3,999 Online
• 468K Conversations
SOLVED

New Contributor

# 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 of cells to behave according to the grade percentage of an adjacent cell. An example would be - If Cell A2 is less than 89.5, or equal to 79.5 display a "B". But I'd also like that cell to display a "C" if it were less than 79.5 or equal to 69.5.  I hope this wasn't confusing. Look forward to your responses!

Kind regards,

Lonnie

Solution

# Re: IF Function

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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies