LengthConvert ( Number , From , To )

Converts Lenghts between m, cm, in, ft and yd

Average rating: 4.2 (30 votes) Log in to vote

Ibrahim Bittar Torres - Show more from this author
Eikonsys, S.A. de C.V.
http://www.eikonsys.com

Sample input:

LengthConvert ( 1 , "in" , "cm" )

Sample output:

2.54

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Number * 

Case (    From = To , 1 ,

          From = "m" and To = "cm" , 1000 , 
          From = "m" and To = "mm" , 1000000 , 
          From = "m" and To = "in" , 39.3700787402 , 
          From = "m" and To = "ft" , 3.280839895 , 
          From = "m" and To = "yd" , 1.093613298 , 

          From = "cm" and To = "m" , 0.01 , 
          From = "cm" and To = "mm" , 10 , 
          From = "cm" and To = "in" , 0.393700787402 , 
          From = "cm" and To = "ft" , 0.03280839895 , 
          From = "cm" and To = "yd" , 0.01093613298 , 

          From = "mm" and To = "m" , 0.001 , 
          From = "mm" and To = "cm" , 0.1 , 
          From = "mm" and To = "in" , 0.0393700787402 , 
          From = "mm" and To = "ft" , 0.003280839895 , 
          From = "mm" and To = "yd" , 0.001093613298 , 

          From = "in" and To = "m" , 0.0254 , 
          From = "in" and To = "cm" , 2.54 , 
          From = "in" and To = "mm" , 25.4 , 
          From = "in" and To = "ft" , 0.083333333333 , 
          From = "in" and To = "yd" , 0.0277777777692 , 

          From = "ft" and To = "m" , 0.3048 , 
          From = "ft" and To = "cm" , 30.48 , 
          From = "ft" and To = "mm" , 304.8 , 
          From = "ft" and To = "in" , 12 , 
          From = "ft" and To = "yd" , 0.3333333332304 , 

          From = "yd" and To = "m" , 0.9144 , 
          From = "yd" and To = "cm" , 91.44 , 
          From = "yd" and To = "mm" , 914.4 , 
          From = "yd" and To = "in" , 36 , 
          From = "yd" and To = "ft" , 3 )

This is a small but useful function if you need to quickly convert between the most common lenght units.

Comments

		Robert Schaub, EastHampton May 31, 2013
Cool ... and Length is spelled wrong And another parameter called Number Function is now Number * Case( .....

		Ibrahim Bittar, LeÃ³n, MX May 31, 2013
Done, thanks for the correction.

		Henk Brendel, Arnhem May 31, 2013
And we do need semicolons instead of commas nowadays...

		Daniele Raybaudi, ACI Jun 1, 2013
It is better to use decimal numbers in the form of a power of 10 ( the dot is not everywhere a symbol of separation of decimals ) So, for example: From = "m" and To = "in" ; 393700787402 10 ^ - 10 ; From = "m" and To = "ft" ; 3280839895 10 ^ - 9 ;

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

LengthConvert ( Number , From , To )

Comments

Support this website.

Support this website.