windows excel help needed

[Peter Normington]

make a new cell with the formula, call it price increase,
then select all the prices (cells) to apply it to, next time you want to increase the prices just enter by how much

Peter

[Stephen Ingham]

Hi peter, thanks for the reply….i must admit it doesnt help….am a little slow i think….

cheers
stephen

[David Rowland]

dont know really

assuming the price is 1.99

=1.99*10%+1.99

or

a1 10%

=1.99*a1+1.99 as peter was suggesting

[Warren Beard]

first column to have price, 2nd column to have equation to add 10%

click column 2 (not whole column just the one cell) and press

=

and then click on column one and type

*10/100

and press enter

if you insert

10

into column one then column 2 should be

11

to continue this equation down click and hold bottom right hand corner of cell (so little + symbol appears) and drag as far down as required, each cell should update accordingly.

hope that makes sense.

cheers

Warren

[Adam McGuire]

Or you could create a new cell with the following:

=A1*1.10

Where "A1" is the cell with the original price

To add 15% change the 1.10 to 1.15
To add 20% change the 1.10 to 1.20
etc
etc

To continue this down the list of prices, click the new cell, and hold shift and click the cell in the same column at the bottom of your list to be updated. The "Edit" -> "Fill" -> "Down"

Hope this helps!

Adam