Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Misc functions

Buy now

Download now

LITlib - Excel Power Functions Pack
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - BodyMassIndex function
litLIB Help
Product pages :
Quick links:
help index

Misc - BodyMassIndex

BodyMassIndex(WeightKg, LengthCM, Optional Format)

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

Calculating the Body Mass Index for a person with a weight of 95kg and a height of 180cm: