Adding multiple cell totals
 

I would like to make a short spread sheet that would for example, start with
a number i.e. 1000 add to that X % then subtract N%. Then carry down 20 or so
lines. Any suggestions would be helpful as usual.
Thanks

Adding multiple cell totals
 

A1: 1000
A2: =A1*(1+x%)*(1-n%)
you supply numbers for x and n
Copy down the column

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"D" wrote in message
...
I would like to make a short spread sheet that would for example, start
with
a number i.e. 1000 add to that X % then subtract N%. Then carry down 20 or
so
lines. Any suggestions would be helpful as usual.
Thanks

Adding multiple cell totals
 

Thanks, works well..



"Bernard Liengme" wrote:

A1: 1000
A2: =A1*(1+x%)*(1-n%)
you supply numbers for x and n
Copy down the column

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"D" wrote in message
...
I would like to make a short spread sheet that would for example, start
with
a number i.e. 1000 add to that X % then subtract N%. Then carry down 20 or
so
lines. Any suggestions would be helpful as usual.
Thanks