Classifying the BMI Using the WHO Classification System with FileMaker Pro

In the previous blog, there was basic information for creating a calculation of the BMI in FileMaker Pro.

The Metabolic Syndrome database uses the World Health Organization (WHO) classification system online at http://apps.nccd.cdc.gov/dnpabmi/ and shown below.

The FileMaker Pro Formula is a nested formula that uses the BMI field in the Visit table.
The double quotes ("") around each classification level instructs FileMaker Pro output text, such as Obesity Class III. Note:  The Metabolic Database used the term "Overweight" instead of "Pre-Obese."

If (BMI >40; "Obesity Class III"; If (BMI>35; "Obesity Class II"; If(BMI>30; "Obesity Class I"; If (BMI>25; "Overweight"; If(BMI ≥ 18.5; "Normal"; If(BMI<18 .5=".5" nderweight="nderweight" p="p">
The data is displayed in the table as seen below.

Table 1: The International Classification of adult underweight, overweight and obesity according to BMI

Classification	BMI(kg/m2)
	Principal cut-off points	Additional cut-off points
Underweight	<18 .50=".50" b="b">	<18 .50=".50" b="b">
Severe thinness	<16 .00=".00" td="td">	<16 .00=".00" td="td">
Moderate thinness	16.00 - 16.99	16.00 - 16.99
Mild thinness	17.00 - 18.49	17.00 - 18.49
Normal range	18.50 - 24.99	18.50 - 22.99
		23.00 - 24.99
Overweight	≥25.00	≥25.00
Pre-obese	25.00 - 29.99	25.00 - 27.49
		27.50 - 29.99
Obese	≥30.00	≥30.00
Obese class I	30.00 - 34.99	30.00 - 32.49
		32.50 - 34.99
Obese class II	35.00 - 39.99	35.00 - 37.49
		37.50 - 39.99
Obese class III	≥40.00	≥40.00