When working with large tables, it is often necessary to make their search easier. One of the ways to do this is by applying the option for conditional formatting, with which we can mark all rows in which a value corresponding to the given criteria was found. In the next “recipe” you will find out how to perform such task.
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.
With the exception of the IF function, Excel has multitude of logical functions that are often unfairly neglected. The AND, OR, and XOR functions are also used to test the one or more conditions. The first returns TRUE if all conditions are met, the second if at least one of the conditions is met, and the third is used to examine cases where at least one but not all conditions are met. These functions can be used to analyze student performance on exams.
Testing of the conditions is done so that, depending on its fulfillment, we will get different results. These can be some concrete values, but most often, depending on the fulfillment of conditions, we devise different formulas for calculating. It is possible to create multiple conditions (multi-branching) or as a condition to specify an index that determines which expression will be calculated. The following text will detail the logical functions for testing the conditions.