Mark Up
I want to calculate a marked up price on an item. IE 15%, 25% etc.
If $100.00 is marked up 15%, the selling price is $117.65 |
Mark Up
=A1/(1-15%)
-- Kind regards, Niek Otten Microsoft MVP - Excel "Egg Harbor" <Egg wrote in message ... I want to calculate a marked up price on an item. IE 15%, 25% etc. If $100.00 is marked up 15%, the selling price is $117.65 |
Mark Up
=A2/(1-15%)
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Egg Harbor" wrote: I want to calculate a marked up price on an item. IE 15%, 25% etc. If $100.00 is marked up 15%, the selling price is $117.65 |
Mark Up
You will have to mark it up more than 15% to get 117.65
Gord Dibben MS Excel MVP On Fri, 15 Jan 2010 09:38:02 -0800, Egg Harbor <Egg wrote: I want to calculate a marked up price on an item. IE 15%, 25% etc. If $100.00 is marked up 15%, the selling price is $117.65 |
Mark Up
Hi,
Let's say you enter the discount in cell B1 (i.e. 0.15 for 15%) in C1 enter =A1/(1-C1) "Egg Harbor" wrote: I want to calculate a marked up price on an item. IE 15%, 25% etc. If $100.00 is marked up 15%, the selling price is $117.65 |
All times are GMT +1. The time now is 09:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com