ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Mark Up (https://www.excelbanter.com/excel-worksheet-functions/253556-mark-up.html)

Egg Harbor

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

Niek Otten

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



Luke M

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


Gord Dibben

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



Eduardo

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