using the same formula for entire rows

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

Guest

I need to use 1 column for wholesale price, and the next column for retail price. The retail price is a function of the wholesale price. I want to write one formula which I can put on the entire column, so when I enter the different products, each product price will automatically calculate the retail price. Right now I am not able to get more than one item to calculate at a time. I have to enter the formula individually for each item. Is there any way to enter a formula which would be good for H, for example?
 
Hi just friends
Assuming A1 is Wholesale and B1 is the retail, once you
have written the formula in B1, all you have to do is
click the bottom right hand corner of cell B1 and drag
down as far as you want to.
Regards
Michael
-----Original Message-----
I need to use 1 column for wholesale price, and the next
Click to expand...
column for retail price. The retail price is a function of
the wholesale price. I want to write one formula which I
can put on the entire column, so when I enter the
different products, each product price will automatically
calculate the retail price. Right now I am not able to get
more than one item to calculate at a time. I have to enter
the formula individually for each item. Is there any way
to enter a formula which would be good for H, for example?
 
Back
Top