Referencing a cell in the same row

[bobisfat]

I need help with using a formula....



I'm trying to use an equation in which I reference a cell thats in the same row. For example, I have Row 1, and Column A full of numbers; and column B, I want to use the number from column A in an equation. So I'm trying to reference the number in row 1, column A to use in row 1, column B, without having to type

"= A1+3" repeatedly because I would like to copy and paste this formula for multiple rows. I've tried using "= A(ROW()) +3" but it doesn't work and I've tried the search function but no luck. Thanks in advance.

[protonLeah]

If you type:
=A1+3
in cell B1, press ENTER, then re-select B1, you will see a small square at the bottom right corner of the selection rectangle about B1. Put the cursor on the square and the cursor will change to a cross. Click and drag the cross down column B to include all the desired rows. Excel will automatically increment the formula as you drag: A2, A3,..., A?

"=A(ROW()) +3" gives an error because there is no such function as "A". What you did here was to try to call function A with the parameter "ROW()" then add 3 to the results returned by the function.

[bobisfat]

If you type:
=A1+3
in cell B1, press ENTER, then re-select B1, you will see a small square at the bottom right corner of the selection rectangle about B1. Put the cursor on the square and the cursor will change to a cross. Click and drag the cross down column B to include all the desired rows. Excel will automatically increment the formula as you drag: A2, A3,..., A?

"=A(ROW()) +3" gives an error because there is no such function as "A". What you did here was to try to call function A with the parameter "ROW()" then add 3 to the results returned by the function.

Thanks, that was very helpful, but I forgot to mention that I have some cell references that I don't want to be changed. For example,

=N2-MIN(N2:N17)

But what you suggested increments the (N2:N17), which I want to be constant. Is there any way to just increment the first N2?

[protonLeah]

Putting "$" in front of the columns and rows in the () will absolutize that range thus:

Please Login or Register  to view this content.

Then, dragging that formula down will only increment the first N2.

[bobisfat]

Putting "$" in front of the columns and rows in the () will absolutize that range thus:

Please Login or Register  to view this content.

Then, dragging that formula down will only increment the first N2.

PERFECT THANKS!

[protonLeah]

You're welcome.