Create Generic Formula for Entire Column
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 |
Create Generic Formula for Entire Column
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 clickPastespecialselect 'Multiply' OK. If this post helps click Yes --------------- Jacob Skaria "Andrea from MN" wrote: 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 |
All times are GMT +1. The time now is 08:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com