how to calculate the next rows (all rows at a time) automatically without calculating

S

sham159

Joined
Oct 16, 2009
Messages
1
Reaction score
0
Good evening everybody,

I just want to ask a question about Microsoft Excel.

How to calculate all old prices in the rows to the price 2010 (RM) in the next rows automatically? The example are as follows :

Price 2010 (RM)Price
(RM)950.334863.94863.94297.403,111.90


The formula is 863.94 x 10% = 8639.40..then 86.3940 + 863.94 = 950.33..
my question is how to calculate the next rows (all rows at a time) automatically without calculating manually?
Please help me..
thanks.
 
Is your old price list in rows or colums?
If in Colum "A" ie A1...to.....A25
Then in colum pfr New price, lets say "C" insert in first row of Colum "c" the
Formula: =(A1+(A1*10%))
then copy down through colum "C" to bottom of list..
All colum "A" figures will be converted to "A" price +10% and displayed in colum "C"
 
If old prices in Rows do the same ish,
At beginning of row put formula
(A1+A1+10%)) A1 or first cell reference
Then fill right to end of worksheet
 
Back
Top