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 Excel formulas of if in the cell below.
Download Excel File