Adding My Profit Margins to Supplyer's Pricelist.xls

[BobSpurlock]

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

 

[Gary''s Student]

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

 

[BenjieLop]

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

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.