Explanation
This example shows one way to calculate BMI (Body Mass Index) in Excel.
The first step, therefore, is to capture this information in commonly used units.
This is done in columns B (feet) C (inches) and D (pounds).
Alternatives
The formulas used above can be simplified somewhat.
When Excel evaluates the formula, this operation happens before the CONVERT function runs.
Not quite as readable, but more compact.
Note: Excel’sorder of operationsmakes it unnecessary to wrap B5*12 in parentheses.
The key point is that you are free tonestother calculations directly in a function argument.
POWER Function
The Excel POWER function returns a number raised to a given power.
The POWER function is an alternative to theexponent operator(^).
