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