SOLVED

function IF

%3CLINGO-SUB%20id%3D%22lingo-sub-1296349%22%20slang%3D%22en-US%22%3Efunction%20IF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1296349%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%26nbsp%3B%3C%2FP%3E%3CP%3EI%20explain%3A%20I%20have%20this%3A%20%22if%2090%26gt%3B80%20%3D%20A%2C%20if%2090%26gt%3B70%20%3D%20B%2C%20else%20%3D%20fail%22%3C%2FP%3E%3CP%3ESo%20I%20wrote%20my%20first%20IF%20and%20now%20in%20the%20part%20%22if%20it's%20wrong%22%20I%20want%20to%20add%20a%20new%20IF%20function%20but%20I%20don't%20succeed%20to%20do%20it..%20If%20someone%20can%20help%20me!%3C%2FP%3E%3CP%3EThank%20you%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1296349%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1296471%22%20slang%3D%22en-US%22%3ERe%3A%20function%20IF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1296471%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F597404%22%20target%3D%22_blank%22%3E%40gyankosh%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20in%20MacOs%20and%20I%20cannot%20find%20this%20function..%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1296407%22%20slang%3D%22en-US%22%3ERe%3A%20function%20IF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1296407%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F616205%22%20target%3D%22_blank%22%3E%40Jeannedv%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20if%20you%20have%20started%20learn%20if%20here%2C%20spend%20some%20time%20here%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fgyankosh.net%2Fmsexcel%2Ffunctions%2Flogical%2Fexcel-function-if%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgyankosh.net%2Fmsexcel%2Ffunctions%2Flogical%2Fexcel-function-if%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efor%20your%20problem%2C%20I%20think%20nested%20if%20is%20good.%20If%20you%20had%20mentioned%20the%20cell%2C%20it'd%20have%20been%20better.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(M%26gt%3B80%2C%22A%22%2C(IF(M%26gt%3B70%2C%22B%22%2C%22FAIL%22)))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EM%20is%20the%20cell%20address%20containing%20the%20marks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2216872%22%20slang%3D%22en-US%22%3ERe%3A%20function%20IF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2216872%22%20slang%3D%22en-US%22%3EPlease%2C%20I'm%20new%20here.%20I%20need%20your%20help%20to%20solve%20this%20problem%20in%20Excel%202016.%20I%20want%20a%20function%20that%20will%20help%20grade%20the%20score%20of%20students%20as%20A%2C%20B%2C%20C%2C%20D%2C%20E%2C%20or%20F.%20The%20formula%20I%20entered%20seemed%20not%20correct.%3CBR%20%2F%3E%3DIFS(G2%26gt%3B80%2C%22A%22%2CG2%26gt%3B70%2C%22B%22%2CG2%26gt%3B60%2C%22C%22%2CG2%26gt%3B50%2C%22D%22%2CG2%26gt%3B40%2C%22E%22%2CTRUE%2C%22F%22)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello! 

I explain: I have this: "if grade>80 = A, if grade>70 = B, else = fail"

So I wrote my first IF and now in the part "if it's wrong" I want to add a new IF function but I don't succeed to do it.. If someone can help me!

Thank you  

4 Replies
best response confirmed by Jeannedv (Occasional Visitor)
Solution

@Jeannedv 

Hi, if you have started learn if here, spend some time here

https://gyankosh.net/msexcel/functions/logical/excel-function-if/

 

for your problem, I think nested if is good. If you had mentioned the cell, it'd have been better.

 

=IF(M>80,"A",(IF(M>70,"B","FAIL")))

 

M is the cell address containing the marks

Please, I'm new here. I need your help to solve this problem in Excel 2016. I want a function that will help grade the score of students as A, B, C, D, E, or F. The formula I entered seemed not correct.
=IFS(G2>80,"A",G2>70,"B",G2>60,"C",G2>50,"D",G2>40,"E",TRUE,"F")

@Olufemi1450 

What's wrong with the formula? It shall work.

@Jeannedv 

 

Here is an example with nested IF functio.

 

It should actually work like Mr. Baklan has already described.

 

Anyway, if it doesn't work then it doesn't work. Too much time to look for it, the easy way chosen

 

Thx all,

Nikolino