Apr 09 2020 11:03 AM - edited Apr 09 2020 11:04 AM
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
Apr 09 2020 11:22 AM
SolutionHi, 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
Mar 17 2021 04:31 AM
Mar 17 2021 12:24 PM
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
Apr 09 2020 11:22 AM
SolutionHi, 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