Formula

  • Thread starter Thread starter Dianna
  • Start date Start date
D

Dianna

On excel how do I add 25 to my previous product
For example: 175 200 250 325
I want a formula to start with 175 then add 25=200
then I want it to take 200 and add 50, 25+25 250
then take 250 and add 75, 25+25+25 325
How do I do this using a formula?
 
in A1, put in 175
in A2 put in
=A1+25

then drag fill down the column.
 
Hello,
may be another soluce ????

in A1, put in 175
in A2 put in
=A1+25*(COUNTA($A$1:A1))
then drag fill down the column.
results:
175
200
250
325
425

Regards
 
Ignore my answer, I just read yout first line description:
On excel how do I add 25 to my previous product

which doesn't appear to be what you want. Fpr that:

If starting in A1
put in 175
then

=A1+(row()-1)*25

if starting in B9 for example
put 175 in B9, in B10 put in

=B9+row(A1)*25

and drag fill down
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top