How to use if statement excel

August 3, 2022
674 Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

Look nowhere except this article if you are surfing the internet to find how to use if statement excel.. But finding its answer without the knowledge is useless. This is essential to get proper results.

The if function compares the values and results in answer in logical comparision, YES or NO. The excel allows you to type the text whatever you want to mention after calculation but the theory behind the IF function remains same. So let’s get started to know how to use if statement excel.



How to use IF function directly

1. In this example, it is required to find whether the actual expnses are over or under budgeted. The problem here can easily be solved using IF function in excel.

2. Click on the Remarks cell in Airfare row.

3. Now type “equals” sign and write “if”. Once you do it, you will notice the IF function appears in the dialogue box.

4. Hit Tab button on keyboard. Now you need to input values in the function. There are three requirements of the IF function to start calculating, the Logical Test, Value If True and Value If False. We will input all these values and get the result.

5. To do this, now click on 1st item in Actual column which is 921. Now type “>” symbol and then click on 1st item on Budgeted column which is 800. This implies the condition to check whether the actual expense is greater than budgeted.

6. Now insert “,” and write in inverted commas as “over budget”. This means that if the condition is true, the text OVER BUDGET will be mentioned.

7. Now insert “,” and type in inverted commas as “under budget”. This indicates to mention UNDER BUDGET if the condition is false.

8. Now hit Enter. You will notice the condition on this expense row applies as OVER BUDGET which is logical.

9. Hover your cursor at the bottom-right corner of the coll. See how the cursor changes to + sign. Click and drag downward upto I10 row and release the button. The IF condition applies to all the expenses.

How to use IF function from menu

1. The example taken here is again the same. Here we will tell you how you can access the same IF function from the menu. This is to show you multiple ways you can access the excel function.

2. Click on the Remarks cell in Airfare row.

3. Head to Formula tab and click it. This opens various options in the ribbon.

4. Now click on Logical button. This opens a drop-down menu.

5. Now click on IF option.

6. Once clicked, you will notice a dialogue box appears with many fields.

7. Now the procedure of entering the data is same as mentioned previously.Click on the button right next to Logical_test.

8. Now click on the H7 cell, insert “>” sign and then click G7 cell. The function should look like this (H7>G7).

9. Hit Enter. This adds value in the field.

10. Now click in the field of Value_if_true and write in inverted commas “Over Budget”. Now click on Value_if_false and write in inverted commas “Under Budget”.

11. Now hit Enter. The answer again comes as Over Budget.

12. Now bring your cursor to the handle of cell at right corner. Notice the cursor changes to PLUS sign. Click and drag downward upto I10 row and release the button. The IF condition applies to all the expenses.

So this is how to use IF statement excel to comapare values in logical statements as YES or NO.


Need to edit Word/Excel/PPT file free of charge? Download WPS Office edit files like without any cost. Download now! to get enjoyable working experience.