anyone know how to create mile function

TheMatrixReloaded · May 15th, 2002, 07:05 AM

anyone know how to create a function that will convert miles to kilometers?
1 mile = 1.6093 kilometers
create a function so that the user can enter a mile amount in a cell the function could reference that cell and show the kilometer amount

PaddyD · May 15th, 2002, 07:10 AM

I might be missing the point here, but if A1 contains the miles value, then =(a1*1.6093) gives you the kilometers.

Post if I've totally misunderstood what the problem is,

Paddy

TheMatrixReloaded · May 15th, 2002, 07:11 AM

it must be a function the user can type in, such as "MileConverter(" whatever. Has to be done in a vba module i think.

Asala42 · May 15th, 2002, 07:15 AM

G'day,

How about for your mile value in A2:

=CONVERT(A2,"mi","m")/1000

(This converts Miles to Meters/1000
Adam

Iain Lewis · May 15th, 2002, 07:15 AM

How about a UDF :

Function MtoKM(miles)
MtoKM = miles * 1.6093
End Function

Asala42 · May 15th, 2002, 07:17 AM

*slaps forehead*

Or actually this should work:

=CONVERT(A2,"mi","km")

Adam

inarbeth · May 15th, 2002, 07:21 AM

I use a useful little utility called Convert which does all sorts of measurement conversions. It can be downloaded at http://www.joshmadison.com/software/convert

cornbread · May 15th, 2002, 07:27 AM

Function Convert(ValRange)
Dim RangeArray As Variant
RangeArray = ValRange.Value
Convert = RangeArray * 1.6093
End Function

Try this insert this code into a module. Type into a cell the number of miles. Go to the cell you want the klick value in and hit the = and go to user defined functions. Choose Convert then for your range pick the cell with the miles in it. This will return the klick value of that mile cell.

cornbread · May 15th, 2002, 07:34 AM

Sorry... klick being slang for Kilometers. Let me know if that is what you wanted or not.

jkpd2000 · May 15th, 2002, 07:49 AM

Hi Inarbeth,

With which software you did this application?
I am just curious whether you did it through excel ?

[ This Message was edited by: jkpd2000 on 2002-05-15 06:49 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 07:05 AM	#1
TheMatrixReloaded New Member Join Date: May 2002 Location: Baltimore Posts: 29	anyone know how to create a function that will convert miles to kilometers? 1 mile = 1.6093 kilometers create a function so that the user can enter a mile amount in a cell the function could reference that cell and show the kilometer amount

May 15th, 2002, 07:10 AM	#2
PaddyD MrExcel MVP Join Date: May 2002 Posts: 13,278	I might be missing the point here, but if A1 contains the miles value, then =(a1*1.6093) gives you the kilometers. Post if I've totally misunderstood what the problem is, Paddy

May 15th, 2002, 07:11 AM	#3
TheMatrixReloaded New Member Join Date: May 2002 Location: Baltimore Posts: 29	it must be a function the user can type in, such as "MileConverter(" whatever. Has to be done in a vba module i think.

May 15th, 2002, 07:15 AM	#4
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,029	G'day, How about for your mile value in A2: =CONVERT(A2,"mi","m")/1000 (This converts Miles to Meters/1000 Adam

May 15th, 2002, 07:15 AM	#5
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	How about a UDF : Function MtoKM(miles) MtoKM = miles * 1.6093 End Function

May 15th, 2002, 07:17 AM	#6
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,029	slaps forehead Or actually this should work: =CONVERT(A2,"mi","km") Adam

May 15th, 2002, 07:21 AM	#7
inarbeth Board Regular Join Date: Apr 2002 Location: Wivenhoe, England Posts: 877	I use a useful little utility called Convert which does all sorts of measurement conversions. It can be downloaded at http://www.joshmadison.com/software/convert

May 15th, 2002, 07:27 AM	#8
cornbread Board Regular Join Date: Apr 2002 Location: Oregon Posts: 77	Function Convert(ValRange) Dim RangeArray As Variant RangeArray = ValRange.Value Convert = RangeArray * 1.6093 End Function Try this insert this code into a module. Type into a cell the number of miles. Go to the cell you want the klick value in and hit the = and go to user defined functions. Choose Convert then for your range pick the cell with the miles in it. This will return the klick value of that mile cell.

May 15th, 2002, 07:34 AM	#9
cornbread Board Regular Join Date: Apr 2002 Location: Oregon Posts: 77	Sorry... klick being slang for Kilometers. Let me know if that is what you wanted or not.

May 15th, 2002, 07:49 AM	#10
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	Hi Inarbeth, With which software you did this application? I am just curious whether you did it through excel ? [ This Message was edited by: jkpd2000 on 2002-05-15 06:49 ]