Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2007

Wendy has attended:
Excel Introduction course

Excel

What is the formula to use to calculate square feet/metres? I can't find it in the formulae ribbon. For example how yould you calculate the area of 5.2m x 2.9m ?
Thanks
Wendy

RE: Excel

Hello Wendy

Thank you for your question and welcome to the forum.

When you create a formula, you can't refer to cells that have a combination of numbers and letters in them - Excel can only use cells that have numbers only in them to figure out a result for you.

What I would suggest is putting 5.2 in one cell (e.g. A1) and 2.9 in another (e.g. B1).

Then in a third cell put in your formula =A1*B1

I hope this helps.

Kind regards
Amanda

Wed 16 Sep 2009: Automatically marked as resolved.

Excel tip:

Copying the same value, label or formula quickly into a range of selected cells.

Select your range of cells. Type the value, label or formula that you want to appear in all the selected cells and then press Ctrl+Enter.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.07 secs.