We need an excel formula that will add A+C fill B and give A for next row and repeat a couple hundred times. We have all C values. Thank you so much in advance!!
A,B,C
785.5,805.0,19.5
805.0,825.1,20.1
825.1,832.9,7.8
A,B,12.4
A,B,24.4
We need an excel formula that will add A+C fill B and give A for next row and repeat a couple hundred times. We have all C values. Thank you so much in advance!!
A,B,C
785.5,805.0,19.5
805.0,825.1,20.1
825.1,832.9,7.8
A,B,12.4
A,B,24.4
A,B,C
785.5,805.0,19.5
805.0,825.1,20.1
825.1,832.9,7.8
A,B,12.4
A,B,24.4
I think what you want is:
In cell B1 the formula is =A1+C1
In A2 the formula is =B1
Not sure what you want with this: A,B,12.4, A,B,24.4
Click on star (*) below if this helps
"I think what you want is:
In cell B1 the formula is =A1+C1 Yes but how can you get that to repeat 300+ times without typing in =A1+C1; =A2+C2 infinite?
In A2 the formula is =B1 Yes however again how do you get that to infinite formula?
Not sure what you want with this: A,B,12.4, A,B,24.4 " These were just examples of continuation of colums
- Put you mouse cursor on the cell containing the formula.
- Using the right mouse button select COPY.
- Move to the cell(s) where you want the formula repeated.
- Holding down the left mouse button, highlight the range of cells where you want the formula repeated
- Click on the right mouse button and select PASTE and hit ENTER
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks