EXCEL VBA MACROS EXERCISES▼
Excel VBA Macros | Functions exercise | Functions for weight, height and BMI
This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
The workbook in the above folder allows you to calculate someone's BMI (body mass index) from imperial measurements:
You could type your name into C2 if you want to use your data
Note that the workbook contains a module containing some built-in constants, to make life easier:
Although you know there are 12 inches in a foot, it makes for clearer coding if you use constants instead
Write as many of the following functions to go in the pink cells shown above as you have time for:
- A function to turn inches and feet into metres, to be used to calculate cell C7
- A function to turn stones and pounds into kilograms, to be used to calculate the figures in column E
- A function to turn height in metres and weight in kilograms into Body Mass Index, using the formula (Weight in kilograms) / (Height in metres squared)
As a guideline, your BMI should be about 20-25. Anything over 25 is considered overweight.
Save this workbook as BMI, and close it down.