adding and subtracting all the way down a column, repeating a formula. I am tryi

Question

adding and subtracting all the way down a column, repeating a formula.

I am trying to figure out a way to repeat a specific formula pattern in excel spreadsheet.

The formula is simple- add two numbers get a total, take the total and subtratct a number for final total and then repeat again taking the final total and adding a number for a total, subtratct a number to get final total over and over again.

add number get total, take total number and subtract a number to get final total, start again.

Thanks a lot :-)

Explanation / Answer

The foundation formula is rather straightforward: =A1+B1-C1

However, what you mean by "repeat a specific pattern" is rather vague. It depends on how the data is arranged & what the intent is as to what else might be involved, such as whether the subtrahend is a constant or a variable.

If nothing more than a list with 1 value in column A, 1 value in column B & the subtrahend in column C, for example, just put that formula in coumn D then copy down as far as necessary.

Another option: With the values in A1 & B1 put =A1+B1 in cell C1, the subtrahend in D1, in E1 usee =C1-D1, then copy it down the column. Or if the subtrahend is a constant just put it in the formuala [e.g., =C1-20 ] or store it in a different single cell such as F1 -- The formula would then be =C1-$F$1.

There are other possibilities as well but without any details attempting to list them all is impractical & pointlesss.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.