Excel Magic Trick 285: Markup On Sell Price Formula

Great video. Thanks for sharing this information.

do you still have the template for this?

how to include this in the resume i did this in my previous organization

Very nice

Very useful! Even in 2022

Can you send me a link to follow along on this video? I can't seem to find it?

Please could you share link to workbook

Could you please send me the EMT 385 Work Book

Sir: If I may, is that 50% margin instead of markup?

How can I make it go down the whole column with out haven to tap it for every roll

Sir...sir... please don't stand too close to your mic

I'm only 11 years late to this but 50% markup 100 is not 200. Nobody caught this? LOL

Hi, Can anyone tell me how to do this on a calculator? I just need to understand it in my head the calculation. Thanks

Hey👋🏻 can you gave me a example of wastage

How do you take into consideration that some costs are fixed and some fluctuate from month to month. Do we use and average?

This is wrong, the 50% markup sale price is 412.5 dollars not 550 dollars.

Can I get this format?

thank you very much you are areak life saver but i couldnt find the link plz i need it

cant find the link

Good day sir. Please how can I calculate the cost of goods sold if I have different prices for one product, e.g one product has a carton price, a dozen price, quarter price, and unit price. will be happy if you can demonstrate that sir.

Can't locate the college uplink tab?

can I have a link for this formula?

Anyone can told me how to add markup (not percentage) on certain value by using excel. Thanks

Thanks very much for this- this is what I have spent all day looking for

How can I download the spreedsheet

you are a hole

So what if the percentage needs to vary according to a specific price range? For instance: $0 - $149, 75% markup; $150 - $199, 65% markup; $200 - $299, 50% markup. Is there a way of calculating this with a formula?

this clip is full of mistakes, I recommend doublecheck the formula to calculate markups

Question. If my cost is $10. I want to make a profit 40% on this item. Is it 10*40%= $4 = 10+4=14. or I should do $10/(1-40%) = $17?

Use his method on second formula but input formula =cost+(markup*cost) on your selected cell for both cost entries push f4 like he does and put $ on percent cell like he does and it will work

Thank you so much exactly what i want

How you got 550$ SP out of 250$ CP for sofa? 275$x(50+100/100)=412,5$ not 550$!!!!!!!!

exactly what I was looking for, thanks!

THank you so much.. it wasnt exactly what i was looking for but you did a great example and i was able to figure it out.

Hi there, congratulations and thanks for sharing it with us. Would you send me the link to download your formulas, please. I couldn't get it.
Thanks very much.

What? Im finding for the 50% of the number but you gave 200%

how can we get cost price if we have only selling price and percentage of profit?
hope you reply soon

thanks

I am using Markup Formulas in the same way but cannot figure out why I get a negative value if the Markup Percentage is Greater than 100%. Can you help??

great tut, thanks, none of your download links are active on your site though

Mind...blown.

Hello i have a problem once I type in more than 100% profit rate = my sales price goes negative ? for example if i want a 120% profit margin the sales price goes negative ? why ? how can i solve this ?

What is mark up for income or sell and buy and number of items and mark up?

It depends on whether you are doing markup on sell price or markup on cost: markup on sell price = (sell price-cost)/sell price markup on cost = (sell price-cost)/cost

I would like a formula that would do the opposite I would like a formula where I could enter my cost and my retail price and would give me the mark up as a percent

noob

You are welcome!

thank you so much life saver! your work is amazing thanks again

I am glad that the videos help! If you want to learn Excel in a more methodical way (instead of watching all the Magic Tricks), you can watch these two Playlists in order: Excel Basics Highline Excel Class These two Playlist have most of the tricks that I know in a logical beginning-to-end order!! To see how to get to the playlists, search for and watch this video title: excelisfun Search for Excel Videos, Playlists & Download Workbooks