“If, Else” Formula in Excel with 4 Examples (Very Easy)

if formula in excel

The Formula “If” “Else” is very important in excel, with the help of If-Else we can do filter anything easily in excel, so here in this article we will tell you some example of If-Else formula. So let started with example as given here under.

Example No. 1 for “If- Else” Formula in Excel :

We are starting with very easy example, here in Cell A2 We will enter a short name of day and in Cell B2 we will get the full name of that Day with the help of if-else function.

So type the formula in cell “B2” as given here under:

=IF(A2=”Su”,”Sunday”,IF(A2=”Mo”,”Monday”,IF(A2=”Tu”,”Tuesday”,IF(A2=”We”, “Wednesday”,IF(A2=”Th”,”Thursday”,IF(A2=”Fr”,”Friday”,IF(A2=”Sa”,”Saturday”,)))))))

if function excel

Now when we will Enter “Mo” in column A2, we will get the result “Monday”

if function excel

Now when we will Enter “Tu” in column A2, we will get the result “Tuesday”

if function excel

Now when we will Enter “We” in column A2, we will get the result “Wednesday”

if function excel

Now when we will Enter “Th” in column A2, we will get the result “Thursday”

if function excel

Now when we will Enter “Fr” in column A2, we will get the result “Friday”

if function excel

Now when we will Enter “Sa” in column A2, we will get the result “Saturday”

if function excel

Example No. 2 for “If- Else” Formula in Excel :

Now we are taking another example to understand the use of if-else formula.

If Column “A2” is Blank then Show the Result that “No Data Found”

If Column “A2” contain any amount then Show that value in Column “C2”

So friends enter the below formula in Column no. “C2”

=IF(A2=””,”No Data Found”,A2)

Result will be as under if Cell A2 is Blank-

if function excel

And Result will be as under if Cell A2 has a value or amount-

if function excel

Example No. 3 for “If- Else” Formula in Excel :

Now we are taking another example in which excel sheet contain a mark sheet of an student, now we will set the formula that if Total marks is below or equal  to 150  than student is “Fail” and if Total Marks is above 150 then student is “Passed”.

So we will set the below formula in cell no. “B9” to get the result in “B9” Cell

=IF(B7>=150,”Passed”,”Fail”)

Here in the below sheet the total marks are above 150 so Result is “Passed”

if function excel

Now we taken the marks of another student as shown under-

The total marks are below 150 so the result is “Failed”

if function excel

Example No. 4 for “If- Else” Formula in Excel :

Here in this example we need the stock status in an office.

The Condition is – if Cell “A2” is iPhone and Cell “B2” is 64 GB then result will be “Available” otherwise result will show “Out of Stock”.

=IF(AND(A2=”iPhone”,B2=”64GB”),”Available”,”Out of Stock”)

We need to paste this formula in every cell of column “C” to get the result of every cell of our data.

if function excel

So, above is the formula to get the result if “iPhone 64GB” is the combination of cells the result is “Available” and if not then result is “Out of Stock”.

if function excel

Friends above are some example of “If, Else” Formula in MS excel we will update more “If, else example to make you better understand “if, else” function.

If you have any question or suggestion, please comment in the comment box we will solve your problem in our next article.


Leave a Reply

Your email address will not be published. Required fields are marked *