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
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):Originally Posted by BobSpurlock
=A2*1.xx
where xx represents your profit margin percentage.
Hope this is what you are looking for.
Regards.
BenjieLop
Houston, TX
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
--
Gary''s Student
"BobSpurlock" wrote:
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks