Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-30-2020, 05:30 AM
kingston123 kingston123 is offline Why "=B3*D" & "=B4*$D" give me same result? Windows 10 Why "=B3*D" & "=B4*$D" give me same result? Office 2013
Advanced Beginner
Why "=B3*D" & "=B4*$D" give me same result?
 
Join Date: Sep 2018
Posts: 75
kingston123 is on a distinguished road
Default Why "=B3*D$2" & "=B4*$D$2" give me same result?

Both formulaes gives me same values in C Column.




Reply With Quote
  #2  
Old 06-30-2020, 07:28 AM
Purfleet Purfleet is offline Why "=B3*D" & "=B4*$D" give me same result? Windows 10 Why "=B3*D" & "=B4*$D" give me same result? Office 2019
Advanced Beginner
 
Join Date: Jun 2020
Posts: 43
Purfleet is on a distinguished road
Default

please add file
Reply With Quote
  #3  
Old 06-30-2020, 11:15 AM
jeffreybrown jeffreybrown is offline Why "=B3*D" & "=B4*$D" give me same result? Windows 10 Why "=B3*D" & "=B4*$D" give me same result? Office 2016
Expert
 
Join Date: Apr 2016
Posts: 610
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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
Reply With Quote
Reply

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
Why "=B3*D" & "=B4*$D" give me same result? 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 03:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft