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”) 
exceldesk.in IF Formula | Learn Excel Formula with Simple Example |
If you want result in the text You must text write in double inverted comma ( “Text” )
you can select cell or Number
exceldesk.in IF Formula | Learn Excel Formula with Simple Example |
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”))
exceldesk.in IF Formula | Learn Excel Formula with Simple Example |

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

Download Excel File

  

Leave a Comment