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 :
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)

litLIB