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?