ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how many square feet to an acre (https://www.excelbanter.com/excel-worksheet-functions/33628-how-many-square-feet-acre.html)

jculjk

how many square feet to an acre
 


Anne Troy

You can always check Google first. A perfectly good answer came up in my
search:
http://www.thepolivkagroup.com/include/calc.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"jculjk" wrote in message
...




Alan Beban

If you can remember that a mile is 5280 ft and a square mile is 640
acres, you can always derive it.

Alan Beban

jculjk wrote:

ScottO

Or you could use the Convert function in Excel -
=CONVERT(number,from_unit,to_unit)
Use the help key for syntax for the "from-unit" & "to_unit"
Rgds,
ScottO

"Alan Beban" wrote in message ...
| If you can remember that a mile is 5280 ft and a square mile is 640
| acres, you can always derive it.
|
| Alan Beban
|
| jculjk wrote:



Alan Beban

Oh really? What's the exact formula to convert from an acre to square feet?

Alan Beban

ScottO wrote:
Or you could use the Convert function in Excel -
=CONVERT(number,from_unit,to_unit)
Use the help key for syntax for the "from-unit" & "to_unit"
Rgds,
ScottO

"Alan Beban" wrote in message ...
| If you can remember that a mile is 5280 ft and a square mile is 640
| acres, you can always derive it.
|
| Alan Beban
|
| jculjk wrote:



ScottO

43,560 apologies - I should have checked that there was support for units of area before opening up
my big keyboard :)

The Convert function doesn't directly support units of area, but can be used for "square units to
square units" conversion. Eg to convert 100 square feet to square metres use the following formula:
=CONVERT(CONVERT(100,"ft","m"),"ft","m")

Rgds,
ScottO

"Alan Beban" wrote in message ...
| Oh really? What's the exact formula to convert from an acre to square feet?
|
| Alan Beban
|
| ScottO wrote:
| Or you could use the Convert function in Excel -
| =CONVERT(number,from_unit,to_unit)
| Use the help key for syntax for the "from-unit" & "to_unit"
| Rgds,
| ScottO
|
| "Alan Beban" wrote in message ...
| | If you can remember that a mile is 5280 ft and a square mile is 640
| | acres, you can always derive it.
| |
| | Alan Beban
| |
| | jculjk wrote:
|
|



Anne Troy

"my big keyboard" LOL!!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"ScottO" wrote in message
...
43,560 apologies - I should have checked that there was support for units

of area before opening up
my big keyboard :)

The Convert function doesn't directly support units of area, but can be

used for "square units to
square units" conversion. Eg to convert 100 square feet to square metres

use the following formula:
=CONVERT(CONVERT(100,"ft","m"),"ft","m")

Rgds,
ScottO

"Alan Beban" wrote in message

...
| Oh really? What's the exact formula to convert from an acre to square

feet?
|
| Alan Beban
|
| ScottO wrote:
| Or you could use the Convert function in Excel -
| =CONVERT(number,from_unit,to_unit)
| Use the help key for syntax for the "from-unit" & "to_unit"
| Rgds,
| ScottO
|
| "Alan Beban" wrote in message

...
| | If you can remember that a mile is 5280 ft and a square mile is 640
| | acres, you can always derive it.
| |
| | Alan Beban
| |
| | jculjk wrote:
|
|






All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com