Excel 2007 : Could use someone smart with forumals x.x

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.

EDIT: Oops sorry pike.

Mr W
Welcome to the forum but, please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Mr w,
please take a few minutes to read the forum rules, and then amend your thread title accordingly. Marcol is right we do not do home work but can assist if you have get stuck on a specfic excel problem

Ensure your question is not too vague. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.


Keep the scope reasonably narrow. Questions like, "How do I set up an accounting system in Excel?" might be a long time waiting.

Explain what you've already tried. ("Calculation is set to automatic, but formulas still don't compute") so helpers don't waste your time or theirs.

Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.