Create Generic Formula for Entire Column

A

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top