I need help with a formula........please

W

Wallie

I have an excel worksheet with pricing........I need to formulate the pricing
with an added 7% mark up.

Help..........Thanks!
 
P

pdberger

Wallie --

Do you mean you want to mark something up 7%? If so, here's one approach:

A B
1 Cost Price
2 $1 =A2*1.07

However, a better way would be to put your markup percentage in a different
cell, so you can change it any time you want:

A B C D
1 Cost Price Markup 7%
2 $1 =A2*(1+$D$1)


Then you can change all the new prices simply by changing D1.

HTH
 
Top