# Why does this 2 formulas gives me same result? (Excel formula Basics)

1. ## Why does this 2 formulas gives me same result? (Excel formula Basics)

Look at this image below, Both formulaes: "=B3*D\$2" & "=B4*\$D\$2" gives me same values in C Column.

BxVzui7.jpg

Both formulas are quite different.  Register To Reply

2. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

Your attached picture doesn't say so ....

.  Register To Reply

3. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

What are you on about? 1 x 5 = 5
2 x 5 = 10

The only difference between the two formulae is the value they are using from column B, otherwise they are identical.  Register To Reply

4. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

I didn't understand difference.  Register To Reply

5. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

B3 = 1
D2 = 5

B3*D2 = 1 x 5 = 5

B4 = 2
D2 = 5

B4*D2 = 2 x 5 = 10

"=B3*D\$2" & "=B4*\$D\$2" gives me same values in C Column
Not so, as can be seen very clearly from your picture.  Register To Reply

6. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

What I am saying is: Whether I use this "=B3*D\$2" or "=B3*\$D\$2", below output is same:

B3 = 1
D2 = 5

B3*D2 = 1 x 5 = 5

B4 = 2
D2 = 5

B4*D2 = 2 x 5 = 10.  Register To Reply

7. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

check out absolute and relative references

As you are filling down a column, rather than across a row, the D reference does not change. It would be the row number that changes but your formula has a \$2 absolute reference to row.  Register To Reply

8. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

That's not what you typed into post #1!!!

You are drag copying DOWN, so you only need to anchor the row, so both will work.

These will NOT work:

=B3*\$D2

=B3*D2  Register To Reply

9. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

I didn't lock D reference by \$ symbol, then why it is not changing?   Register To Reply

10. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

D is a column reference - when you drag copy down, that doesn't change, so there is no need to anchor it, but you MUST anchor the row (2). In your picture the row is anchored and both of your examples in post #1 have the row anchored. That's why it works.  Register To Reply

11. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

post#1 first formulae says =B3*D\$2. Here D is not locked (not anchored in your words)  Register To Reply

12. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

No, it doesn't need to be.  Register To Reply

13. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

How to visualize the locked reference?  Register To Reply

14. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

Type =AA2 into cell A1.

Drag copy across and down and inspect the results.

Then do the same with =AA\$2, =\$AA2 and =\$AA\$2 in turn.

That's it from me - nothing more I can do to help.

I have yet to see any word of gratitude from you to any of those who have offered you help over the past few days. This really is very discourteous of you.  Register To Reply

15. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

Look below the results of D\$2, \$D2 and \$D\$2

Attachment 684760  Register To Reply

16. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

Those results are correct.  Register To Reply

17. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

I am just asking simple question, why D\$2, \$D2 are giving me same results?   Register To Reply

18. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

It has been answered several times. Please review posts #7, 8, 10 and 14 in particular.

These give the same results: D\$2, \$D\$2

These do not: D2, \$D2  Register To Reply

19. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

An unanchored column will change if you copy the formula to a NEW column. In your example, you are copying to the same column and therefore it doesn't change. Therefore it does not have to be anchored (either way, D will remain D since you didn't copy across columns).  Register To Reply

20. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

As I said in post #10:

D is a column reference - when you drag copy down, that doesn't change, so there is no need to anchor it, but you MUST anchor the row (2).  Register To Reply

21. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

Marked as solved and still not one word of thanks to any of us. Shocking!   Register To Reply

22. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

Thank you.   Register To Reply

23. ## Re: Why does this 2 formulas gives me same result? (Excel formula Basics)

At last - first time this week! Wasn't hard, was it?  Register To Reply