SOLVED
Home

IF Function

%3CLINGO-SUB%20id%3D%22lingo-sub-309955%22%20slang%3D%22en-US%22%3EIF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309955%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20figure%20out%20what%20the%20function%20or%20formula%20might%20be%20if%20I%20wanted%20a%20cell%20to%20display%20a%20letter%20if%20an%20adjacent%20cell%20displayed%20a%20certain%20number.%26nbsp%3B%20For%20instance%2C%20I'm%20a%20teacher%20and%20I%20want%20a%20column%20of%20cells%20to%20behave%20according%20to%20the%20grade%20percentage%20of%20an%20adjacent%20cell.%20An%20example%20would%20be%20-%20If%20Cell%20A2%20is%20less%20than%2089.5%2C%20or%20equal%20to%2079.5%20display%20a%20%22B%22.%20But%20I'd%20also%20like%20that%20cell%20to%20display%20a%20%22C%22%20if%20it%20were%20less%20than%2079.5%20or%20equal%20to%2069.5.%26nbsp%3B%20I%20hope%20this%20wasn't%20confusing.%20Look%20forward%20to%20your%20responses!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3ELonnie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-309955%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-310000%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-310000%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20You%20could%20nest%20IF%20formulas%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3DIF(A2%26lt%3B69.5%2C%22D%22%2CIF(A2%26lt%3B79.5%2C%22C%22%2CIF(A2%26lt%3B89.5%2C%22B%22%2C%22A%22)))%3C%2FPRE%3E%3CP%3E(I%20am%20assuming%20anything%20less%20than%20the%20range%20for%20C%20is%20a%20D%20and%20anything%20above%20the%20range%20for%20B%20is%20A%20in%20the%20Example%20above.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Lonnie White III
New Contributor

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

1 Reply
Solution

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