Calculate BMI Category
I need to check if the calculated BMI is above 25 and label it 'Overweight'. For children and adolescents, BMI interpretation is age and sex-specific, but for a quick adult-equivalent screening, I'm using a general threshold.
=IF(B2>25,"Overweight","Normal") How it works: The IF function evaluates a logical test. In this case, `B2>25` checks if the BMI in cell B2 is greater than 25. If this condition is TRUE, the formula returns the value 'Overweight'. If the condition is FALSE (meaning BMI is 25 or less), it returns 'Normal'. This provides an immediate categorization for quick assessment.
Data Setup
| Patient Name | BMI |
|---|---|
| Alice | 22.5 |
| Bob | 26.1 |
| Charlie | 19.8 |
| Diana | 28.0 |
| Eve | 24.9 |
| Frank | 25.0 |
Step-by-Step Guide
Ensure your patient's calculated BMI values are in a column (e.g., Column B, starting from B2).
Select the cell where you want the first BMI category to appear (e.g., C2).
Enter the formula: `=IF(B2>25,"Overweight","Normal")`.
Press Enter. The cell will display 'Overweight' if the BMI in B2 is greater than 25, or 'Normal' otherwise.
Drag the fill handle (the small square at the bottom-right of cell C2) down to apply the formula to the rest of your patient data.