Create Generic Formula for Entire Column

[Andrea from MN]

I am guessing there is an easy answer to this question and I am really hoping
someone can help me out. What I want to do is take prices in one column and
discount them to a sale price in another column. I don't want to keep
entering in the the same formula into each cell but wanted to know if there
was an easier way to do it. So here I go:

Formula I am trying: =PRODUCT (B*.6)

Column B: Has Regular Priced Items (3000 to be exact)
Column L: Has Sale Price Heading

I want to be able to have all regular priced items 40% off. Is there a way
to type in one formula into column L to get the same results for all cells.
Can I somewhere type the above formula or do I need to do this in each
column? What I am hoping NOT to do is go into each cell and edit the formula.
For example,

Column L

L3 =PROD(B3*.6)
L4 =PROD(B4*.6)
L5 =PROD(B5*.6)

Am I going to have to go down the entire row and do this or can I just do
one equation that will work for every cell?

Thanks so much in advance!

Andrea

 

[Jacob Skaria]

Hi Andrea

--In L3 try the below formula and copy/drag the cell down as required.. The
formula will auto adjust the cell reference as B4,B5 etc;
=B3*.6

--If you want to permanently change the values then type 0.6 in a separate
cell. Copy the cell. Keeping the copy select Column B Values. Right
click>Pastespecial>select 'Multiply' >OK.

If this post helps click Yes