Learn Microsoft Excel

Hi,
In this modern age microsoft excel has become important for every person who is engaged in any type of business. This tool help you to prepare more complex calculation easily with built-in functions. Such as preparing Costing and Budgeting sheets, making leasing schedule, amortization and depreciation schedule, etc. This website will enable you to learn and understand the excel and also you can ask any query relating to excel and we will answer you through your e-mail address.

Tuesday, January 25, 2011

How the IF Function Works

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