• 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.

Mark up%

Pinang

Member
Hi,

I want a automated formula in Key to tally my both amount in attached excel file.

Please help.
 

Attachments

  • Markup%.xlsx
    11.7 KB · Views: 10
Thanks Narayan.

What will be formula if my Scenario changes as per requirements?

Attached file for reference.
 

Attachments

  • Markup%.xlsx
    16.2 KB · Views: 4
Hi ,

What are these new calculations you have made , along with a factor of 20% ?

If you are going to change your calculations each time, then every scenario will require a new formula.

Narayan
 
Hi,

Margin is calculating on basis of 20% of cost and new mark up%. I am getting solution through Goal Seek function but I am looking for formula for the same.

Thanks.
 
Hi,

Margin is calculating on basis of 20% of cost and new mark up%. I am getting solution through Goal Seek function but I am looking for formula for the same.

Thanks.
Hi ,

I am sorry , but I have not been able to find any way of arriving at the optimal key value given the new scenario.

Narayan
 
Back
Top