Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
circular reference | Excel Worksheet Functions | |||
Circular Reference | Excel Worksheet Functions | |||
Circular Reference | Excel Discussion (Misc queries) | |||
how to: circular reference | Excel Worksheet Functions | |||
Circular reference | Excel Worksheet Functions |