#1
|
|||
|
|||
Why "=B3*D$2" & "=B4*$D$2" give me same result?
Both formulaes gives me same values in C Column.
|
#2
|
|||
|
|||
please add file
|
#3
|
|||
|
|||
And they should give the same results. In essence, both are the same.
In the first reference >> =B3*D$2 >> the 2 (row) is absolute >> so as you drag down, the row 2 reference stays the same. It's locked down as absolute. In the second reference >> =B4*$D$2 >> the 2 (row) and the column (D) are both absolute >> so as you drag down, the row 2 stays the same and so does the column (D). So, you don't actually need to lock the column reference since you are dragging the formula down. You would only have to lock the column if you are dragging to the right and you want it to stay on column D. Switch between relative, absolute, and mixed references - Excel |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combine "sort within groups" and "identify duplicate/unique values" in two different variables. | civilcervant | Excel | 3 | 06-12-2017 07:27 AM |
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N | mikey386 | Excel | 2 | 12-11-2014 01:14 PM |
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas | jocke321 | Word VBA | 2 | 12-10-2014 11:27 AM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
"Microsoft Excel Application" missing in the "Component Services" on win08 | sword.fish | Excel | 0 | 02-26-2010 02:09 PM |