Sales markup plus fee

[Mike Banner]

Newbie needs help.
I need a working formula for taking a base price + 100, then multiplying by
38 %.
Any help would be appricaited.

 

[Pimamedic]

=sum(a1+b1)*.38+a1

Where A1 is base price
B1 is 100

 

[M Kan]

Are you marking up the base price by 38% (e.g., x 138%) or are you
discounting the base price + factor to 38%?

 

[Mike Banner]

I'm taking a base price (C2) then adding $100 for installation, then
multiplying by 38% to get (D2).

 

[Mike Banner]

FYI, I'm using Excel 2007. Not sure if that helps. Thanks for your help.

 

[Mike Banner]

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]

make sure that 100 is in the B column

So A column is base price
B Column is 100
C Column is formula

 

[Gord Dibben]

Is calculation set to Automatic?


Gord Dibben MS Excel MVP