Remember Me?

#1
March 17th 08, 11:00 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Mar 2008 Posts: 1
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?

#2
March 17th 08, 11:24 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 527
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?

#3
March 17th 08, 11:33 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Feb 2008 Posts: 221
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.

#4
March 17th 08, 12:20 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 527
Convert decimals to area measurement

Forget my last post Arggh!

=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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Shannon Excel Worksheet Functions 4 March 6th 08 04:33 AM Curious Excel Worksheet Functions 2 November 14th 06 11:34 PM J-EL Excel Discussion (Misc queries) 3 September 17th 06 12:58 AM dharmik Excel Worksheet Functions 2 March 30th 06 07:48 PM dharmik Excel Worksheet Functions 1 March 28th 06 07:12 PM

All times are GMT +1. The time now is 06:23 AM.

The comments are property of their posters.