HELP... Commission of 20% if an employee makes more than 2.7 times their wages

I have an issue in Excel 2007 that I do not have the formula knowledge to write.

We own a hairdressers and wish to display targets to our employees. We have a spreadsheet that is working fine for each employee.

As an example say “Tom” has earned £897.03 (I15) this month and we have paid him £353.92 (I25)

We have used the below calculation to work out a simple % =I15/I25-1 = 153%

Here is my issue.

We want to be able to give a commission of 20% if he makes more than 2.7 times his wages.

Can this be done?

Hi, I have just tried that formula and if the *2.7 is stepped up or down to say 2.6 or 2.8 then it displays 0.00 until 2.4 which is odd to me. Also can I ask what the 0.2 plays in the formular?

Ok, I think I see where I have not explained it very well. The 20% is only paid out on the amount above 2.7 times their wage and not the whole amount. So for instance, if the x2.7 hteir wage took them to say £300, only the amount above this would be paid at 20%. Sorry.

Thank you very much, so easy when you know how.