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
Eikonsys, S.A. de C.V.
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
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.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.