“If, Else” Formula in Excel with 4 Examples (Very Easy) | if else example 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.

Download Free Excel Files

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group
Nazim Khan - Author Image

Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]

Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.

1 thought on ““If, Else” Formula in Excel with 4 Examples (Very Easy) | if else example in excel”

  1. Sir, I am submitting one Excel situation and work to do as under.

    Situation.A) In sheet 1 i want to type names of students. Few have done homework, few have not done homework and few have incomplete homework.
    B) There are three other worksheets namely 1)Homework Done, 2) Homework not done, 3) Homework incomplete.

    Work:- 1) In sheet 1, I want to fill names of the students with their homework situation (done/not done/incomplete).
    2) But as i fill names in sheet 1 i want their names (Row) auto filled in concerned sheets.

    As i am new to Excel, I hope i have managed to say what i want to do.

    Sir, kindly guide me through Video.

    Reply

Leave a Comment