Excel Magic Trick 285: Markup On Sell Price Formula

See how to calculate Sales Price given Cost and Markup On Sales Price.

Sells Price = Cost/(1-Markup On Sales Price)

Base = Part1/Rate1
Base = Part2/Rate2
Base = Part1/(1-Rate2)
Base = Part2/(1-Rate1)

Category:

Science & Technology

Tags:

• Excel
• calculate
• Sales
• Price
• Cost
• Markup
• On
• formula
• Business
• Math
• Baste
• Rate
• Part
• Percent
• of
• Change
• excelisfun
• Mike
• Gel
• Highline
• Community
• College

[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]

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

[PrincessWithSkills]

I hope you reference this video for absolute/relative cell references on your playlists. Very good explanation and examples of a difficult concept. THANKS

[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

[Gravity43kg]

Thanks!!! you make the hardest things easy :)

[ExcelIsFun]

Dear Gravity43kg,

You are welcome!

--excelisfun

[ExcelIsFun]

Dear Gravity43kg,

Maybe something like:

=IF(Acutal sales was > forecasted sales, display a figure, VLOOKUP function)

--excelisfun

[Gravity43kg]

Ive got a Question eXcel master... I had a Quesrion in class where a If and Vlookup as incorporated in one cell...i had no idea how to do it.

The coloum had to display a figure in the colum if Acutal sales was > forecasted sales.

If not then nothing in the colum...and if the # was greather than just say 200 then it would display a V lookup for a value...how do i type in this using ony (the actual sales colum, the budget column and the V lookup cells??)