| Let's start with an employee whose name and | | | | the problem using the 'if' function in Excel? |
| salary you have entered in an Excel worksheet. | | | | The situation is not very different when a teacher |
| Based on his basic salary you pay him a holiday | | | | wishes to define grades for students based on |
| allowance. Now people who get 'x' salary are paid | | | | the total percentage marks that a student gets. |
| 60% of the salary as holiday allowance and | | | | Other situations where you can use 'if' and |
| people who get 'y' salary are paid 80% of the | | | | multiple 'if' would be where you have different |
| salary as holiday allowance. This is a | | | | 'VAT' (Value Added Tax) values for the products |
| straightforward calculation if you have a small | | | | you sell. You could also apply the 'if' function to |
| amount of data, let's say, 5 or 6 entries. What | | | | calculate taxes based on the total salary package |
| happens if you have 100 or thousands of entries. | | | | and the tax tables provided by the revenue |
| You just can't drag the cell handle and copy the | | | | collection department. |
| formulas ('autofill') because different values are | | | | Other interesting related functions are 'sumif and |
| applicable to different employees. What happens if | | | | 'countif'. If you have used the simple 'conditional |
| you wish to use another factor in the calculation | | | | formatting' function in Excel, then you know how |
| like designation of the employee. So, now if | | | | effective this function is to highlight important |
| somebody is a manager and he draws a 'x' salary, | | | | data based on your criteria! |
| then you want to give him 100% of monthly | | | | To see the use of 'if' and other related functions |
| salary as holiday allowance and if another | | | | in action, please follow the links to the free Excel |
| employee is a manager and he is drawing 'y' | | | | training videos given below. |
| salary you want to give him 85% of monthly | | | | Till the next article - take care! |
| salary as holiday allowance. How can you solve | | | | |