| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sales markup plus fee
Newbie needs help.
I need a working formula for taking a base price + 100, then multiplying by 38 %. Any help would be appricaited. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sales markup plus fee
=sum(a1+b1)*.38+a1
Where A1 is base price B1 is 100 "Mike Banner" wrote: Newbie needs help. I need a working formula for taking a base price + 100, then multiplying by 38 %. Any help would be appricaited. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sales markup plus fee
My worksheet my be corrupted. I can't get it to work. Each base price changes
from row to row, but the sum is the same. "Pimamedic" wrote: =sum(a1+b1)*.38+a1 Where A1 is base price B1 is 100 "Mike Banner" wrote: Newbie needs help. I need a working formula for taking a base price + 100, then multiplying by 38 %. Any help would be appricaited. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sales markup plus fee
Is calculation set to Automatic?
Gord Dibben MS Excel MVP On Thu, 24 Jul 2008 13:38:01 -0700, Mike Banner wrote: My worksheet my be corrupted. I can't get it to work. Each base price changes from row to row, but the sum is the same. "Pimamedic" wrote: =sum(a1+b1)*.38+a1 Where A1 is base price B1 is 100 "Mike Banner" wrote: Newbie needs help. I need a working formula for taking a base price + 100, then multiplying by 38 %. Any help would be appricaited. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sales markup plus fee
Are you marking up the base price by 38% (e.g., x 138%) or are you
discounting the base price + factor to 38%? -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Mike Banner" wrote: Newbie needs help. I need a working formula for taking a base price + 100, then multiplying by 38 %. Any help would be appricaited. |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sales markup plus fee
I'm taking a base price (C2) then adding $100 for installation, then
multiplying by 38% to get (D2). "M Kan" wrote: Are you marking up the base price by 38% (e.g., x 138%) or are you discounting the base price + factor to 38%? -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Mike Banner" wrote: Newbie needs help. I need a working formula for taking a base price + 100, then multiplying by 38 %. Any help would be appricaited. |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sales markup plus fee
FYI, I'm using Excel 2007. Not sure if that helps. Thanks for your help.
"M Kan" wrote: Are you marking up the base price by 38% (e.g., x 138%) or are you discounting the base price + factor to 38%? -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Mike Banner" wrote: Newbie needs help. I need a working formula for taking a base price + 100, then multiplying by 38 %. Any help would be appricaited. |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sales markup plus fee
make sure that 100 is in the B column
So A column is base price B Column is 100 C Column is formula "Mike Banner" wrote: FYI, I'm using Excel 2007. Not sure if that helps. Thanks for your help. "M Kan" wrote: Are you marking up the base price by 38% (e.g., x 138%) or are you discounting the base price + factor to 38%? -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Mike Banner" wrote: Newbie needs help. I need a working formula for taking a base price + 100, then multiplying by 38 %. Any help would be appricaited. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logarithmic Retail Markup Worksheet | Excel Worksheet Functions | |||
| Remove html markup tags in an EXCEL cell? | Excel Discussion (Misc queries) | |||
| Remove html markup | Excel Worksheet Functions | |||
| Formula for markup won't change when the initial value is changed. | Excel Worksheet Functions | |||
| Margin/markup formula for Excel | New Users to Excel | |||
![Mike Banner[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
