Newest functions Upload a function Leave a tip My account

There are 2,577 functions in this library.

AreaConvert ( Width , Wunit , Height , Hunit , OutUnit )

Calculates areas based on multiple units

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

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

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

Let ( [ WFactor = Case ( Wunit = "mm" and OutUnit = "cm2" ; .1 ; Wunit = "mm" and OutUnit = "m2" ; .001 ; Wunit = "mm" and OutUnit = "in2" ; .039370079 ; Wunit = "mm" and OutUnit = "ft2" ; .0032808399 ; Wunit = "cm" and OutUnit = "mm2" ; 10 ; Wunit = "cm" and OutUnit = "m2" ; .01 ; Wunit = "cm" and OutUnit = "in2" ; .39370079 ; Wunit = "cm" and OutUnit = "ft2" ; .03280839895 ; Wunit = "m" and OutUnit = "mm2" ; 1000 ; Wunit = "m" and OutUnit = "cm2" ; 100 ; Wunit = "m" and OutUnit = "in2" ; 39.370079 ; Wunit = "m" and OutUnit = "ft2" ; 3.280839895 ; Wunit = "in" and OutUnit = "mm2" ; 25.4 ; Wunit = "in" and OutUnit = "cm2" ; 2.54 ; Wunit = "in" and OutUnit = "m2" ; .0254 ; Wunit = "in" and OutUnit = "ft2" ; .083333333333 ; Wunit = "ft" and OutUnit = "mm2" ; 304.8 ; Wunit = "ft" and OutUnit = "cm2" ; 30.48 ; Wunit = "ft" and OutUnit = "m2" ; .3048 ; Wunit = "ft" and OutUnit = "in2" ; 12 ; 1 ) ; HFactor = Case ( Hunit = "mm" and OutUnit = "cm2" ; .1 ; Hunit = "mm" and OutUnit = "m2" ; .001 ; Hunit = "mm" and OutUnit = "in2" ; .039370079 ; Hunit = "mm" and OutUnit = "ft2" ; .0032808399 ; Hunit = "cm" and OutUnit = "mm2" ; 10 ; Hunit = "cm" and OutUnit = "m2" ; .01 ; Hunit = "cm" and OutUnit = "in2" ; .39370079 ; Hunit = "cm" and OutUnit = "ft2" ; .03280839895 ; Hunit = "m" and OutUnit = "mm2" ; 1000 ; Hunit = "m" and OutUnit = "cm2" ; 100 ; Hunit = "m" and OutUnit = "in2" ; 39.370079 ; Hunit = "m" and OutUnit = "ft2" ; 3.280839895 ; Hunit = "in" and OutUnit = "mm2" ; 25.4 ; Hunit = "in" and OutUnit = "cm2" ; 2.54 ; Hunit = "in" and OutUnit = "m2" ; .0254 ; Hunit = "in" and OutUnit = "ft2" ; .083333333333 ; Hunit = "ft" and OutUnit = "mm2" ; 304.8 ; Hunit = "ft" and OutUnit = "cm2" ; 30.48 ; Hunit = "ft" and OutUnit = "m2" ; .3048 ; Hunit = "ft" and OutUnit = "in2" ; 12 ; 1 ) ] ; Width * WFactor * Height * HFactor ) Click to copy

This custom function calculates an area based on Widths and Heigths with multiple input and output units.

Width and Height can be expressed in milimeters, centimeters, meters, inches and feet. Calculated area can be expressed in square millimeters, square centimeters, square meters, square inches and square feet.

You can use any combination of these units in the Width, Height and Area and the CF will calculate the final area accordingly.

For example: let's suppose you have a Width of 10 inches, a Height of 15 centimeters and you want to express the area in square feet. In this case you could use a calculation like this:

AreaConvert ( 10 , "in" , 15 , "cm" , "ft2" ) and the result will be 0.4101049868733596 square feet.

 

Comments

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: