Feb 19 2021 09:43 PM
I'm not able to use IF functions in cell directly..... I've to go to logical tab again and again to use the formula...
Feb 19 2021 10:21 PM
Since font size is smaller so that unable to see the formula properly, but meanwhile I would like so suggest two best possible formula:
=IF(F88>=70,"A",IF(F88>=60,"B",IF(F88>=50,"C","D")))
=VLOOKUP(F88,{0,"D";50,"C";60,"B";70,"A"},2)
N.B.
Feb 19 2021 11:03 PM
@iamagarwalx I believe the error is caused by the "tripple" quotation mark in your formula.
Replace it with a regular quotation mark, just like the others. Then it shall work.
Feb 20 2021 07:09 AM
If only other ones are double quotes, not repeated two times single quotes