Are you overweight? Weight gain is not just an aesthetic problem, it can be the cause of many diseases, so companies conduct an annual physical examination to check the health of their employees. In this example, you will learn how to calculate BMI (Body Mass Index), a coefficient that indicates whether you are below or above the optimal body weight, and how to use conditional formatting to mark those who have unfavorable BMI.
Besides basic calculating operators like addition (+), subtraction (-), multiplication (*), and division (/) Excel contains even a handful of functions that we can use to perform various mathematical operations. Also, there are functions for calculating the absolute value, returning the number sign, and some other functions that can be of importance, for example, to create conditions in conditional formatting, when we want to color each different order in different colors …