IF functions not working

Occasional Visitor

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...Always shows this lineAlways shows this line 

3 Replies

@iamagarwalx 

Since font size is smaller so that unable to see the formula properly, but meanwhile I would like so suggest two best possible formula:

 

Rajesh-S_0-1613801910475.png

  • 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. 

Screenshot 2021-02-20 at 07.57.30.png

Replace it with a regular quotation mark, just like the others. Then it shall work.

@iamagarwalx 

If only other ones are double quotes, not repeated two times single quotes