The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Excel

Resolved · High Priority · Version 2007

ReplyWed 9 Sep 2009, 10:47Delegate Wendy said...

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

For upcoming training course dates see: Pricing & availability

ReplyWed 9 Sep 2009, 11:48Trainer Amanda said...

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 articles

· Creating Top Tables With Excel
· Discover The Difference Between Line And XY Scatter Charts In Excel
· How Teachers Are Using Microsoft Excel To Enhance Learning in the Classroom
· How To Make Excel Open A Particular File When It Launches
· Tips for Transitioning to Excel 2007

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips

N/A

» Forum post: N/A

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions