Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Convert Sq Ft to Sq Meters

3 views
Skip to first unread message

Karl O'Donoghue

unread,
Nov 5, 2001, 3:10:13 PM11/5/01
to
Can anyone help with a function to convert square feet to
square metres and vice versa?
Sincèrement ...
Karl O'Donoghue

Otto Moehrbach

unread,
Nov 5, 2001, 4:10:17 PM11/5/01
to
Assuming your source is in A1, type this in B1.
=A1*.0929 to convert square feet to square meters.
=A1*10.76 to convert square meters to square feet. Otto
"Karl O'Donoghue" <kaodo...@airfrance.fr> wrote in message
news:18c801c16635$e099a4f0$a4e62ecf@tkmsftngxa06...

Debra Dalgleish

unread,
Nov 5, 2001, 4:11:42 PM11/5/01
to
Assuming 1 square metre = 10.76391 square foot

use that value to convert, e.g.:

=B5/10.76391 (where B5 is sq ft)

or
=B5*10.76391 (where B5 is sq m)

Mike Chambers

unread,
Nov 5, 2001, 4:21:52 PM11/5/01
to
You could just use the conversion factors:

Sq Ft ---> Sq M ---> multiply by 0.0929
Sq M ---> Sq Ft ---> multiply by 10.76

>.
>

Karl O'Donoghue

unread,
Nov 5, 2001, 4:41:37 PM11/5/01
to
Thank you for illuminating me.
Sincerely ...
KO.

>.
>

Ron Rosenfeld

unread,
Nov 5, 2001, 5:01:17 PM11/5/01
to


Another approach if you have the analysis toolpak installed

Sq Ft --> Sq M =convert(SQRT(A1),"ft","m")^2

Sq M --> Sq Ft ==convert(SQRT(A1),"m","ft")^2

--ron

Dana DeLouis

unread,
Nov 5, 2001, 11:32:20 PM11/5/01
to
A slightly different idea could remove the Sqrt function....

=A1*convert(1,"ft","m")^2

--
Dana DeLouis Windows Me & Office XP

"Ron Rosenfeld" <ronros...@spamcop.net> wrote in message
news:0p2eutcbb2pp7s9to...@4ax.com...

Ron Rosenfeld

unread,
Nov 6, 2001, 7:18:39 AM11/6/01
to
On Mon, 5 Nov 2001 23:32:20 -0500, "Dana DeLouis" <ng_...@hotmail.com>
wrote:

>A slightly different idea could remove the Sqrt function....
>
> =A1*convert(1,"ft","m")^2

Would probably compute more quickly, too.

--ron

0 new messages