Forum Discussion
Solved
function IF
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 ...
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
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")What's wrong with the formula? It shall work.
