i need help entering a formula in excel?

Question

=b41+(B3-B11+(B6/B18))

i am doing the thing where you highlight that formula and drag it down from the little box in the bottom right of the cell to increment the formula onto other cells.

what i want is for ONLY b41 to increment and none of the other cells in the formula.

so it would go b41, b42, b43.....but all the other values would stay the same. ...how can i do this?

Answer 1

Any cell value reference can be locked by adding the $ marker in the specification.
For instance $B15 will allow increment of the 15 but lock the B. B$15 will lock the 15 but allow the B to change after a copy and paste. $B$15 locks both the B and the 15.

Answer 2

B41+($B$3-$B$11+($B$6/$B$18))

The $ lock the reference. $B3 would lock the column and increment the row, B$3 would lock the row and increment the column.$B$3 would lock the B and the 3

Answer 3

do this

=B41+($B$3-$B$11+($B$6/$B$18))

The $ lock the reference. $B3 would lock the column and increment the row, B$3 would lock the row and increment the column.

If you drag down or across, both the column and row of "b41" will increment leaving the rest fixed

Answer 4

You can put in a $ in front of the row and column identifiers that you don't want to change.

=b41+($B$3-$B$11+($B$6/$B$18))

Answer 5

If you want the value of the column to not change, write it as $B5 instead of B5

If you want the value of the row to not change, write it as B$5 instead of B5

If you want the value of the cell not to change (no row change or no column change), write it as $B$5 instead of B5.

Hope that helps ;-)

Answer 6

I like to name my cells and then write formulas using those names.

Use:
insert>name>define

Give that cell a name and then use it in your formulas.

Answer 7

Try putting $b?$ where ? is all other numbers except 41. This may work.....