Is anyone familiar with Goal Seeker. I need to use it to determine the break even point. I have variable costs and fixed costs as well as the selling price of item. How do I use Goal Seeker to get the info?
Which parameter do you want to change to achieve break-even? This parameter must be a constant value and not based on formula in order for you to use goal seek.
Goal seek is pretty straightforward. Just set the cell where the net profit value is to 0 (zero) and set the BY CHANGING CELL to the parameter that is changeable.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
