# Excel formulas of if | Learn Excel IF Formula with Simple Example | Excel Formulas | Excel Functions

## Excel formulas of if

### What if excel formulas ?

Ans :- If formula use for show  multiple  condition Result.
When Cell Value or Text match with our logical condition excel gives result what we want.
Ex. I want make Result sheet  Pass or Fail Student. I can use “IF formula” with passing criteria.
First Condition is if student exam subject result is equal to or more than 35 then I want result PASS.
Second condition If student get marks less then 35 then Result shows FAIL. This condition we can put in Excel formulas of if.
Condition – IF value >35 then “Pass” else “Fail”
Formula in Sheet
=IF(C5>=35,”Pass”,”Fail”) If you want result in the text You must text write in double inverted comma ( “Text” )
you can select cell or Number
You can use multiple
Condition id if value is 0 then result will be NIL, if value is more than 0 then result will be Debit or Dr & value is less then 0 then result is Credit or Cr.

IF Value = 0 then NIL
Value >0 then  Dr
Value <0then   Cr

Here we are put formula with three condition.
Excel formulas of if in Sheet

=IF(E12=0,”Nil”,IF(E12>0,”Dr”,”Cr”))

In the first cell put the formula & copy it and paste the Excel formulas of if in the cell below.