• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Price change using GOAL SEEK

AV114

Member
am trying to build a price card, and I want to change the selling price (using goal seek)so i will get my production cost, but while adding the formulas into name manager GOAL seek is not providing the production cost.

Am attaching the excel file . Could you please help me on this or any other way in VBA or other tools
 

Attachments

  • PC.xlsx
    8.7 KB · Views: 6
Goal seek simply requires two cell addresses (by name or direct reference) and a typed in value. Otherwise you could start with the Selling Price and work the calculation backwards.
 

Attachments

  • PC (1).xlsx
    14.1 KB · Views: 2
If you do cross-post, please provide that link in your post,

so readers can learn answer from the other forum also, as well as stopping people wasting their time on your answered question.

Regards
Bosco
 
Back
Top