Simple Excel Formula Help [Solved/Closed]

Report
-
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
-
Hello,






Hey guys I'm doing some project on Excel for a class. When it comes to entering and creating formulas, I'm borderline handicapped. Does anyone know what to make of this?

Enter a formula into cell B7 that calculates the gravity felt by the astronaut on Mercury wearing the space suit. The formula is the percentage (in row 5) times the sum of the weight of the astronaut (in column A) and the weight of the space suit (in cell A2). You should use absolute formulas for this.

Haaalp. Also, much thanks in advance.

1 reply

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!