| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Foot mark aka single quote mark? | Excel Worksheet Functions | |||
| How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
| # mark | Excel Worksheet Functions | |||
| The mark is bugging me! LOL | Excel Worksheet Functions | |||
| Mark up and Margin | Excel Worksheet Functions | |||
Linear Mode
