View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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!!