Edit: Ok, fixed. I had the Mark Up formulas wrong.
Edit: The Mark Up computation sheet is not working properly. Have to do some trouble shooting. Arrggg.
Ok, I've revised the worksheet to be more inline with what you want to do. Don't ask me why, guess I was just bored.
It now consists of three tables. Each table includes these fields.
Cost = Cost of item
Sell = What the item does or will sell for
Mark Up = Percentage the item is marked up from Cost
Profit AR = Profit after royalties and Cost subtracted.
Profit % = Percentage of profit after royalties and Cost are subtracted.
Table one computes all other fields based on Cost and Sell price.
Table two computes all other fields based on Cost and Mark Up (Percentage)
Table three computes all other fields based on Cost and Profit %
To the best of my knowledge all formulas work. They can be double checked by entering the output of one table into the input of the other and making sure that all values match.
There are probably a few formatting mistakes I didn't catch.
Profits Worksheet.numbers