Adding My Profit Margins to Supplyer's Pricelist.xls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I format an entire column to add a fixed percentage to the number in
each row and display the anwer in the same row, next column?
Please help,
Bob
 
Let's say the supplier's price is in column A and you want the values in
columnB to reflect a &% markup over supplier price. In cell B1 enter the
formula:

=A1*1.07 and copy down. The marked up prices will be in column B
 
BobSpurlock said:
How can I format an entire column to add a fixed percentage to the
number in
each row and display the anwer in the same row, next column?
Please help,
Bob
Click to expand...

Assuming that A2:A100 contains your supplier's prices, then enter this
in Cell B2 (copy down until B100):

=A2*1.XX

where xx represents your profit margin percentage.

Hope this is what you are looking for.

Regards.
 
Back
Top