|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 13th, 2009, 03:06 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage Increase Tables
I am trying to create a price list where Column A is the wholesale price,
column B is the trade price and Column C is the retail price. I want to take the figure in ColA and increase it by 85% to give a retail figure in Col C. The problem I have is that in A each row has a different amount. How can I create a formulae where it automatically changes the ColA to ColA1, ColA2 etc to save me writing individula formuale for each line. At the moment I have to manually write in Col C the formulae =A1*(1+85%) to give me the retail total for colomn C. Then go to Line A2 and do the same but changing the formulae to =A2*(1+85%). Is there a way to do this in excel that will automatically change the A1 to 2, then 3 etc so I only write the formulae once? Same thing applies to Col B but Col B total needs to be Col c Total less 20%. Help apprecaited 
|
|
#2
May 13th, 2009, 03:11 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage Increase Tables
You need only type the formula as =A1*(1+85%) and paste down. Please go to
Tools Options Calculation tab and ensure calculation is set to Automatic. Same would go for column B formula. "Julia123" wrote: I am trying to create a price list where Column A is the wholesale price, column B is the trade price and Column C is the retail price. I want to take the figure in ColA and increase it by 85% to give a retail figure in Col C. The problem I have is that in A each row has a different amount. How can I create a formulae where it automatically changes the ColA to ColA1, ColA2 etc to save me writing individula formuale for each line. At the moment I have to manually write in Col C the formulae =A1*(1+85%) to give me the retail total for colomn C. Then go to Line A2 and do the same but changing the formulae to =A2*(1+85%). Is there a way to do this in excel that will automatically change the A1 to 2, then 3 etc so I only write the formulae once? Same thing applies to Col B but Col B total needs to be Col c Total less 20%. Help apprecaited
|
|
#3
May 13th, 2009, 03:17 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage Increase Tables
Sean Timmons;343747 Wrote: You need only type the formula as =A1*(1+85%) and paste down. Please go to Tools Options Calculation tab and ensure calculation is set to Automatic. Same would go for column B formula. "Julia123" wrote: I am trying to create a price list where Column A is the wholesale price, column B is the trade price and Column C is the retail price. I want to take the figure in ColA and increase it by 85% to give a retail figure in Col C. The problem I have is that in A each row has a different amount. How can I create a formulae where it automatically changes the ColA to ColA1, ColA2 etc to save me writing individula formuale for each line. At the moment I have to manually write in Col C the formulae =A1*(1+85%) to give me the retail total for colomn C. Then go to Line A2 and do the same but changing the formulae to =A2*(1+85%). Is there a way to do this in excel that will automatically change the A1 to 2, then 3 etc so I only write the formulae once? Same thing applies to Col B but Col B total needs to be Col c Total less 20%. Help apprecaited Hi, alternatively enter your formula in C1 and double click the handle at the lower right corner of the cell when it is selected. The formula will extend as long as there is data in the column left of it ( and right since 2003 I think) -- Pecoflyer Cheers - ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96162
|
|
#4
May 13th, 2009, 04:31 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage Increase Tables
Fantastic, thanks Sean problem solved and it worked perfectly which has saved
me a chore. thanks again. Julia "Pecoflyer" wrote: Sean Timmons;343747 Wrote: You need only type the formula as =A1*(1+85%) and paste down. Please go to Tools Options Calculation tab and ensure calculation is set to Automatic. Same would go for column B formula. "Julia123" wrote: I am trying to create a price list where Column A is the wholesale price, column B is the trade price and Column C is the retail price. I want to take the figure in ColA and increase it by 85% to give a retail figure in Col C. The problem I have is that in A each row has a different amount. How can I create a formulae where it automatically changes the ColA to ColA1, ColA2 etc to save me writing individula formuale for each line. At the moment I have to manually write in Col C the formulae =A1*(1+85%) to give me the retail total for colomn C. Then go to Line A2 and do the same but changing the formulae to =A2*(1+85%). Is there a way to do this in excel that will automatically change the A1 to 2, then 3 etc so I only write the formulae once? Same thing applies to Col B but Col B total needs to be Col c Total less 20%. Help apprecaited Hi, alternatively enter your formula in C1 and double click the handle at the lower right corner of the cell when it is selected. The formula will extend as long as there is data in the column left of it ( and right since 2003 I think) -- Pecoflyer Cheers - ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96162
|
|
#5
May 13th, 2009, 06:12 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage Increase Tables
That's why the pay us the big bucks.. wait.. I don't get paid for this? :-)
"Julia123" wrote: Fantastic, thanks Sean problem solved and it worked perfectly which has saved me a chore. thanks again. Julia "Pecoflyer" wrote: Sean Timmons;343747 Wrote: You need only type the formula as =A1*(1+85%) and paste down. Please go to Tools Options Calculation tab and ensure calculation is set to Automatic. Same would go for column B formula. "Julia123" wrote: I am trying to create a price list where Column A is the wholesale price, column B is the trade price and Column C is the retail price. I want to take the figure in ColA and increase it by 85% to give a retail figure in Col C. The problem I have is that in A each row has a different amount. How can I create a formulae where it automatically changes the ColA to ColA1, ColA2 etc to save me writing individula formuale for each line. At the moment I have to manually write in Col C the formulae =A1*(1+85%) to give me the retail total for colomn C. Then go to Line A2 and do the same but changing the formulae to =A2*(1+85%). Is there a way to do this in excel that will automatically change the A1 to 2, then 3 etc so I only write the formulae once? Same thing applies to Col B but Col B total needs to be Col c Total less 20%. Help apprecaited Hi, alternatively enter your formula in C1 and double click the handle at the lower right corner of the cell when it is selected. The formula will extend as long as there is data in the column left of it ( and right since 2003 I think) -- Pecoflyer Cheers - ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96162
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
