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: