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

**If function**.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

**in the cell below.***Excel formulas of if***Download Excel File**