Simple Excel Formula Help
Solved/Closed
Spoola
-
Jun 5, 2011 at 06:57 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 6, 2011 at 08:32 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 6, 2011 at 08:32 AM
Related:
- Simple Excel Formula Help
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jun 6, 2011 at 08:32 AM
Jun 6, 2011 at 08:32 AM
Hi Spoola,
You say the percentage is in row 5. But which column? I'm guessing B.
You say the weight of the astronaut can be found in column A. But which row? I'm guessing 5.
The formula will look like this:
=B5*(A5+A2)
Absolute cell references are used to prevent the change of cell references when being dragged.
To make a cell reference absolute, select the cell in the formula bar and hit F4. Hitting F4 multiple times will cycle through the available options: Absolute row and column, only row, only column, cancel action.
You can also manually add a $ symbol in front of the letter or number or both.
I have no idea which cell refeernce you want to make absolute, but now you know how it works.
Best regards,
Trowa
You say the percentage is in row 5. But which column? I'm guessing B.
You say the weight of the astronaut can be found in column A. But which row? I'm guessing 5.
The formula will look like this:
=B5*(A5+A2)
Absolute cell references are used to prevent the change of cell references when being dragged.
To make a cell reference absolute, select the cell in the formula bar and hit F4. Hitting F4 multiple times will cycle through the available options: Absolute row and column, only row, only column, cancel action.
You can also manually add a $ symbol in front of the letter or number or both.
I have no idea which cell refeernce you want to make absolute, but now you know how it works.
Best regards,
Trowa
