The Excel IF function adds flexibility to your spreadsheet by introducing decision making. It does this by testing a specified condition in your spreadsheet to see if it is true or false.
If the condition is true, the function will carry out one action. If the condition is false, it will carry out a different action.
The function allows you to specify what actions it should carry out depending on whether the condition is true or not. These actions can include executing a formula, inserting a text statement, or leaving the target cell blank.
This tutorial uses the IF function to calculate a fictitious annual deduction for employees based on their yearly salary.
The function tests to see if an employee's salary is above or below the threshold of $30,000. If the salary of employee exceed $30,000 then 6% will be deducted otherwise 8% will be deducted.

No comments:
Post a Comment