Using IF formula Problems in Excel

In this video we can discuss about Using IF Formulas in Excel Sheet.

Using IF formula

Total = Telugu + Hindi + English

Grades:-

Two grades:-
=IF(Total>value,”A”,”B”)

Three grades :-
= IF(Total>=High Value,”A”,IF(Total>=Middle value,”B”,”C”))

Pass & Fail:-
=IF(AND(Telugu>35,Hindi>35,English>35),”Pass”, “Fail”)