An Interesting Payroll Solution

Excel 2007
Excel 2003
Macros Excel 2007
Macros Excel 2003
Excel 2010
Home

Find a payroll solution: For all employees getting a salary less than 20000 units, calculate the House Rent Allowance (HRA) at 130% of salary and for all others getting a salary greater than 20000 allow a HRA of 110% of salary but with a ceiling of 30000.
Watch the video below to see how this achieved using a combination of the IF and MIN functions:



Home
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010