litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Misc - BodyMassIndex

Syntax:
BodyMassIndex(WeightKg, LengthCM, Optional Format)

Description:
Calculates the Body Mass Index for an individual given the weight in kg and the length in cm.

The optional format parameter can be used to get different output formats:
format=1 : BMI - classification : e.g. 29 - overweight
format=2 : Just the BMI value: e.g. 29.23
format=3 : Just the classification: e.g. overweight

Example:
Calculating the Body Mass Index for a person with a weight of 95kg and a height of 180cm:
=BodyMassIndex(95,180)
=litlib.xls!BodyMassIndex(95,180,1)
=litlib.xls!BodyMassIndex(95,180,2)
=litlib.xls!BodyMassIndex(95,180,3)