Copying formula from column to another
Closed
Walido001
Posts
3
Registration date
Tuesday March 11, 2014
Status
Member
Last seen
August 16, 2014
-
Aug 16, 2014 at 07:49 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 18, 2014 at 10:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 18, 2014 at 10:26 AM
Related:
- Copying formula from column to another
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Aug 18, 2014 at 10:26 AM
Aug 18, 2014 at 10:26 AM
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
