ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Convert decimals to area measurement (https://www.excelbanter.com/excel-worksheet-functions/180285-convert-decimals-area-measurement.html)

ajmull

Convert decimals to area measurement
 
I am working on a history project in which I need to convert acreage given in
decimal form to acres, roods and perches (40 perches = 1 rood; 4 roods = 1
acre). Is is possible to do this in Excel?

Billy Liddel

Convert decimals to area measurement
 
Ajmul

Returns a text value =INT(A6*4)& " Roods" & " " &MOD(A6*4,4)& " Perches"

I have not tried it for fractions of an acre

Peter

"ajmull" wrote:

I am working on a history project in which I need to convert acreage given in
decimal form to acres, roods and perches (40 perches = 1 rood; 4 roods = 1
acre). Is is possible to do this in Excel?


NoodNutt

Convert decimals to area measurement
 
G'day Ajmull

Try this:

Formula View:
Columns

A B C
Row 1 Acres Roods Perchs
Row 2 Your input =A2*4 =B2*40

Actual View:

Columns

A B C
Row 1 Acres Roods Perchs
Row 2 1 4 160


HTH
Mark.



Billy Liddel

Convert decimals to area measurement
 
Forget my last post Arggh!

Try instead
=INT(A6*4)& " Roods" & " "&(A6*4-INT(A6*4))*160 & " Perches"

where the decimal acreage is in A6

Peter

"Billy Liddel" wrote:

Ajmul

Returns a text value =INT(A6*4)& " Roods" & " " &MOD(A6*4,4)& " Perches"

I have not tried it for fractions of an acre

Peter

"ajmull" wrote:

I am working on a history project in which I need to convert acreage given in
decimal form to acres, roods and perches (40 perches = 1 rood; 4 roods = 1
acre). Is is possible to do this in Excel?



All times are GMT +1. The time now is 10:44 PM.

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