Please help!
I have a spreadsheet of commissions worked out by employee depending on hours worked etc, this is driven by cell E3 having the net profit figure entered and then it calculates the total commission in G3
The entry I have from the accounts are as below, I wanted to be able to link E3 into P6 but I am getting a circular error due to P3 being the sum of G3, is there another way I can do this calculation?
Thank you
I have a spreadsheet of commissions worked out by employee depending on hours worked etc, this is driven by cell E3 having the net profit figure entered and then it calculates the total commission in G3
The entry I have from the accounts are as below, I wanted to be able to link E3 into P6 but I am getting a circular error due to P3 being the sum of G3, is there another way I can do this calculation?
Thank you