Beginner
In the first exercise, we will focus on variables and some calculations. This is a nice follow up to the Hello world tutorial in Beginner tutorials on VBA.
Body mass index (BMI) is a value derived from the mass (weight) and height of a person. It is a convenient rule of thumb used to broadly categorize a person as underweight, normal weight, overweight, or obese.
The BMI is defined as
Your task is to create a sheet where you can calculate your BMI by entering your name, height and weight. The calculated BMI should be displayed by the click of a button. A draft to a finished solution is shown below.
Commonly accepted BMI ranges are:
BMI [kg/m2] | |
|---|---|
| Underweight | < 18.5 |
| Normal weight | 18.5 - 25 |
| Overweight | 25 - 30 |
| Obese | > 30 |