Excel Magic Trick 285: Markup On Sell Price Formula

See how to calculate Sales Price given Cost and Markup On Sales Price.
Download Excel file: people.highlin...
Sells Price = Cost/(1-Markup On Sales Price)
Base = Part1/Rate1
Base = Part2/Rate2
Base = Part1/(1-Rate2)
Base = Part2/(1-Rate1)

[@bohairston7742]

Great video. Thanks for sharing this information.

[@excelisfun]

You are welcome!!!

[@excelisfun]

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

[@vikasquadros]

Hey man...u r doing a great job!!...have followed all ur previous 200 videos..and now i am seeing the next 200 videos and it simply rocks!!!...your teaching is simply surperb...keep up the good work..!!!

[@excelisfun]

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

[@MoThingsEmpire]

I’m confused, can you explain what is the different in the markup on sell price and markup on cost and in which case would you use each formula . Is there a series that teaches building a pricing spreadsheet for selling and figuring out profit margin Also you pressed F2 and backspace 4 time is that necessary or can you just plug in the $ sign.

[@excelisfun]

@@MoThingsEmpire Video 41 in this class: kzbin.info/aero/PLrRPvpgDmw0kMy6GdNvsecPSOP5Tc_ydL

[@excelisfun]

You are welcome!

[@emilymiller1522]

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?

[@excelisfun]

Dear Gravity43kg, Maybe something like: =IF(Acutal sales was > forecasted sales, display a figure, VLOOKUP function) --excelisfun

[@MelindaAbshireDomainiches]

Very Instructive, as always. Thank you!

[@crazyfruitbatjpn]

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

[@avig8334]

Very useful! Even in 2022

[@elizabethhernandezr9814]

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.

[@excelisfun]

Dear PrincessWithSkills, Do you see a Playlist for Cell References? I don't see one any more, even though I used to have one!?!? --excelisfun

[@paulinandhlovu6180]

Hi ! great tutorials .This is exactly what landed me on your page. Please help with the link to download the templete.

[@excelisfun]

Download Excel file: people.highline.edu/mgirvin/KZbinExcelIsFun/EMT285-294.xls

[@1leepeh]

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

[@excelisfun]

Dear Gravity43kg, You are welcome! --excelisfun

[@vidyapati106]

Very nice

[@kennethpiposar653]

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

[@kaleidopescope]

exactly what I was looking for, thanks!

[@hemanth96571]

Thank you so much exactly what i want

[@AdamvdWalt]

Please could you share link to workbook

[@psycho_savage_26gaming39]

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

[@psycho_savage_26gaming39]

As an example I used the following =$B13+(C$12*$B13)

[@datalab365]

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.

[@roclobster1211]

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

[@G3UNLIMITED]

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

[@ICECREAAAAAAM8I8]

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

[@erict5678]

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?

[@trevonlaugier8391]

It's the latter. The exact figure is $16.70 I think

[@paulreader1777]

Profit % = Profit/Cost Price × 100 but Net Profit Margin(%) = (Net Income/Revenue) x100 The difference is in the denominator and usually results in NPM reporting a lower figure. In the example from the sheet where the formula used is Cost/(1-Markup on Selling Price) with 50% the actual percentage profit is 100%, 55% its 145% and 60% it is 167%.

[@justme23lol]

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

[@ryanvdmerwe]

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

[@BrazilBrasil2014]

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.

[@hiteshjoshi3148]

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

[@abelsimonyan4193]

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

[@malorini86]

do you still have the template for this?

[@TXCHRISZ06]

Mind...blown.

[@garybollands]

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??

[@Rayscafes]

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

[@globalsolution168]

Can I get this format?

[@gorillashop337]

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

[@fuchsiacards]

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

[@unclelarsoutpost5797]

Can't locate the college uplink tab?

[@gracecalm]

can I have a link for this formula?

[@humberto1978ful]

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 ?

[@trixielabrador7385]

Hey👋🏻 can you gave me a example of wastage

[@fahadbhn]

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

[@paulreader1777]

A little algebra will help: Let A be the (unknown) cost price, B the (known) selling price and C the known percentage profit. Since Profit % = Profit/Cost Price × 100 and Profit = Selling price - Cost price we have C= (B-A)x 100/B multiplying both sides by B we have BxC = (B - A)x100 or BxC/100 = B-A Solving for A gives A = B/(1+C/100) . Lets take an example Selling price (B) might be $120 and percentage profit (C) 20% applying the formula A = 120/(1+20/100) = 120/1.2 = 100, as you would expect: a 20% profit on an item purchased for 100 gives a selling price of 120. The formula for A above works for all selling prices and percentage profits.

[@gerhardpretoriusg]

How can I download the spreedsheet

[@hime6216]

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

[@ronniegriffin8561]

cant find the link

[@skyxbloods6979]

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

[@chrischeek6532]

Could you please send me the EMT 385 Work Book

[@swiftjones4700]

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

[@wawawawawawa5266]

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

[@dianedufrene7071]

Wawawa Wawawa I'm seeing 100% mark up on the selling price instead of 50%

[@paulreader1777]

@@dianedufrene7071 Correct but the 50% shown in the grid is markup on selling price not on cost price - it is the net profit margin which is another measure of profitability that always makes it look as if profits are lower.

[@sofloemir]

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

[@diegoramirezdaza]

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

[@paulreader1777]

As presented with the stated formula the clip is correct!