Forum Discussion
IF functions not working
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 line
3 Replies
If only other ones are double quotes, not repeated two times single quotes
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.
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.
