Please find the sheet shown below as a picture:
In regards to the percentages, I will make myself more clear -
If the number in the Actual Box (Cell B13) is less than 70% of the number in the Target box (Cell B11) the desired outcome is for a 0 to be shown in the Comms box (Cell B16)
If the number in the Actual Box (Cell B13) is between 70-99% of the number in the Target box (Cell B11) the desired outcome is for 7.5% of Actual Box Value (Cell B13) is to be shown in the Comms box (Cell B16
If the number in the Actual Box (Cell B13) is between 100-120% of the number in the Target box (Cell B11) the desired outcome is for 10% of Actual Box Value (Cell B13) is to be shown in the Comms box (Cell B16)
If the number in the Actual Box (Cell B13) is 121+% of the number in the Target box (Cell B11) the desired outcome is for 12.5% of Actual Box Value (Cell B13) is to be shown in the Comms box (Cell B16)
I understand this is a complicated formula and I am very grateful for your help.