Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular Reference (Two problems)
Hi Folks,
I use a spreadsheet to calculate cost of a project which includes commission percentage. The commission is a percentage of the sell price (COST+TAX+MARK-UP). But the sell price includes a mark-up of the commission (COST+TAX+MARK-UP+COMMISION+MARK-UP=SELL PRICE). 1. I have a problem with a circular reference. I changed the ³Limitation² to 1 but the excel XLS does not always remember this preference. 2.The total sell price changes every time I click SAVE even though the cells have not been altered. Also, If I had a sell price then I zeroed out all the costs, there is still figures in the totals cell even though there are no figures cells. There should be 0.00. There¹s a ghost in the machine. John Chavez Los Angeles, CA Mac OS 10.5/MacBook Pro/Mac Office 2008 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular Reference (Two problems)
Let S = sales price Let C = Commision Let P = Other costs (cost + markup) S = (S * C) + P S - (S * C) = P S(1-C) = P S = P / (1-C) "John Chavez" wrote: Hi Folks, I use a spreadsheet to calculate cost of a project which includes commission percentage. The commission is a percentage of the sell price (COST+TAX+MARK-UP). But the sell price includes a mark-up of the commission (COST+TAX+MARK-UP+COMMISION+MARK-UP=SELL PRICE). 1. I have a problem with a circular reference. I changed the ³Limitation² to 1 but the excel XLS does not always remember this preference. 2.The total sell price changes every time I click SAVE even though the cells have not been altered. Also, If I had a sell price then I zeroed out all the costs, there is still figures in the totals cell even though there are no figures cells. There should be 0.00. There¹s a ghost in the machine. John Chavez Los Angeles, CA Mac OS 10.5/MacBook Pro/Mac Office 2008 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
circular reference | Excel Worksheet Functions | |||
Circular Reference | Excel Discussion (Misc queries) | |||
Circular reference | Excel Discussion (Misc queries) | |||
Circular Reference | Excel Discussion (Misc queries) | |||
Having problems with a circular reference and the #VALUE! error | Excel Programming |