Copying formula from column to another
Closed
Walido001
Posts
3
Registration date
Tuesday 11 March 2014
Status
Member
Last seen
16 August 2014
-
16 Aug 2014 à 07:49
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 18 Aug 2014 à 10:26
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 18 Aug 2014 à 10:26
Related:
- Copying formula from column to another
- Protect pdf from copying - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel column number - Guide
- How to delete a column in word - Guide
- Spreadsheet formula - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
18 Aug 2014 à 10:26
18 Aug 2014 à 10:26
Hi Walido,
Your question is about relative (changing) and absolute (fixed) cell references.
By default the cell references are relative but can be made absolute by adding a dollar sign ($) in front of either the column or row reference or both.
Long story short; you formula in D2 should look like:
=$B2*C2
Best regards,
Trowa
Your question is about relative (changing) and absolute (fixed) cell references.
By default the cell references are relative but can be made absolute by adding a dollar sign ($) in front of either the column or row reference or both.
Long story short; you formula in D2 should look like:
=$B2*C2
Best regards,
Trowa
