Circular Reference for Commission %
 

I am calculating the total cost of a job, which includes the commission. Of
course, as the commission is calculated, it increases the cost of the job,
which increases the commission, etc.
How can I resolve this issue so the total sales price shows the correct
commission?
Example, I want to sell a job for $10,000, and the commission at 7% would be
$700, so I want the total sales price to be $10,700.
This is driving me CRAZY!!

Circular Reference for Commission %
 

In A2: 10000
In B2: 7%
Then in C2: =A2*(1+B2)
will return the required total
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"David" wrote:
I am calculating the total cost of a job, which includes the commission. Of
course, as the commission is calculated, it increases the cost of the job,
which increases the commission, etc.
How can I resolve this issue so the total sales price shows the correct
commission?
Example, I want to sell a job for $10,000, and the commission at 7% would be
$700, so I want the total sales price to be $10,700.
This is driving me CRAZY!!