Formulas

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

Dianna

how do i add a compounding number in a formula?
example: 125,150,200,275,375,500
125+25=150
150+25+25 OR 150+50=200
200+25+25+25 OR 200+75=275
i think i need the formula to compound 2 things
the number i start(A)with and also the number i add to (A)
 
One way:

A1: 125
A2: =A1+25*(ROW()-1)

Copy A1 down as far as desired.
 
You must log in or register to reply here.

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

Similar Threads

Change Zoom Box Amounts 3
sumif by multiple condition 5
Weighted average using SUMIF and/or SUMPRODUCT 3
Formula setup 2
3 COLOR SCALE CONDITIONAL FORMATING WITH FORMULAS 3
How do I express the following calculation. 3
formulas 2
I'm a Newbie, Need Formula 5

Back
Top