|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 17th 08, 11:00 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? 
|
| Ads |
|
#2
March 17th 08, 11:24 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| convert fractions to decimals | Shannon | Excel Worksheet Functions | 4 | March 6th 08 04:33 AM |
| How do I convert 4'6" into decimals? | Curious | Excel Worksheet Functions | 2 | November 14th 06 11:34 PM |
| Bond prices convert to decimals | J-EL | Excel Discussion (Misc queries) | 3 | September 17th 06 12:58 AM |
| Convert Lats and longs to decimals | dharmik | Excel Worksheet Functions | 2 | March 30th 06 07:48 PM |
| convert lats and longs to decimals | dharmik | Excel Worksheet Functions | 1 | March 28th 06 07:12 PM |
Linear Mode
