How to use if function on excel

Majority of excel users often ponder how to use if function on excel? This question will be answered in this article. But you must first be clarified about its theory, what is its function. This is essential to get proper result.

The if function is undoubtedly popular and well known function because it gives logical comparision between two or multiple values. The result in using the if function will either output true or false. It can not result any other term so this is one important thing to remember. Whatever the text may be, but the concept is the same. Assign a condition for true and false, tell excel what to appear in the cell when the condition meets or does not meet the criteria. In this tutorial, you will get to know how to use if function on excel in step-wise procedure.

How to use IF function directly

1. A sample document is opened here. This is a basic level expense sheet with budgeted and actual amount. The task here to get result whether the expense it over or under budgeted. The IF function is useful here.

2. Click on the Remarks cell in Airfare row.

3. Type “equals” sign and write “if”. Notice the IF function appears.

4. Click Tab button on keyboard. Now the IF fucntion is active and requires some input. The Logical_test is the field to insert the condition, the Value_if_true is the field where you decide what to show in case the value meets the condition, Value_if_false is where you decide what to mention in case the comparision does not match.

5. lick 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 interprets 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. Now bring your cursor at handle at right corner of cell. 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.

How to use IF function from menu

1. The example shows expense sheet with budgeted and actual amount and it is reqiured to write remakrs whether its over budgeted or under budgeted. The IF function is useful here.

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. Click in the field of Value_if_true and write in quotation marks “Over Budget”. In Value_if_false 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 + 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 on excel? It is used 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.