I have a problem using goal seek! Enclosed file is showing our GM calculations for a given product. To calculate our GM a dicount and bonus is deducted from the Gross price and freight costs (calculated as a percentage of Gross price after discount) are added to the purchase price. What I would like is to be able to calculate the Gross price (yellow cell) when all the already known data (green cells) are keyed in and the GM is the target (red cell). This means I would like to key in a new GM, f.ex. 45%, and then receive the new Gross Price.....
Thanks a lot for your help in advance
Bookmarks