In the first exercise, we will focus on variables and some calculations. This is a nice follow up to the Hello worldtutorial 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
There are as always a number of ways to solve this task, so don't be alarmed if your answer differentiates from our solution.