Need to add a certain percentage to a column of prices

G

Glowinafuse

Okay, Now how do I change the percentage? Like lets say I want to change
it from the 20% to 25%. How do I input that? Cause i will have other
items which will require hiher percenatge markup?

Please let me know. You guys have been great!!!

Glowinafuse
 
P

Peo Sjoblom

Or it could be put in another cell as percentage and use

=A1*(1+B1)

where B1 would hold the percentage

Regards,

Peo Sjoblom
 
B

Barb R.

For the items that require a higher markup, you'll need to change this equation

(in B1) = A1*1.2

to

=A1*1.25

In the appropriate fields.
 
Top