I have a data set with 10,000+ items. I am trying to convert the square footage to acreage. Every item has a different square footage and I want to type in a function that will convert each 10,000 or so items to the specific acreage. E.g. item number 6 is 30056.4 square feet and I want the column beside it to populate 0.0047 acres and so on and so forth.
1 sq. feet is
So, when you have a data like this:
Make a column for acres, and use this formula:
Drag down to fill other cells in the column:
ROUND() will round-off the values to the decimal places that you specify. Using this formula will round-off the values in acres to 4 decimal places.