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...
Since font size is smaller so that unable to see the formula properly, but meanwhile I would like so suggest two best possible formula:
- Formula in cell G88:
=IF(F88>=70,"A",IF(F88>=60,"B",IF(F88>=50,"C","D")))- Another is in cell H88:
=VLOOKUP(F88,{0,"D";50,"C";60,"B";70,"A"},2)
N.B.
- In case these doesn't works then edit your post & share the formula with us you have tried so far.
- Adjust cell references & ranks as needed.
@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.
