Hi,
I'm making a basic spreadsheet with simple formulas and I'm drawing a blank. I have a formula with simple math =A4+B3. I would like to include this formula for the whole column, yet when I do that it repeats the answer for the last row with an entry. (See the "40" below). How can I get the formula to be there, but not the "40"? I hope this makes sense.
A BOB 16 16 7
A 2nd 12 28 3
A 2nd 12 40 3
40
40
40
40
40
I'm making a basic spreadsheet with simple formulas and I'm drawing a blank. I have a formula with simple math =A4+B3. I would like to include this formula for the whole column, yet when I do that it repeats the answer for the last row with an entry. (See the "40" below). How can I get the formula to be there, but not the "40"? I hope this makes sense.
A BOB 16 16 7
A 2nd 12 28 3
A 2nd 12 40 3
40
40
40
40
40