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.

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.

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.

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.

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.

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.

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.

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.