How to group range of numbers into categories of number ranges in Google Sheets
I have a column of the range of body mass index numbers (BMI) that I want to automatically group into categories or buckets in another column. It looks like this:
colA colB
BMI BMI Grouping
23.11 BMI ≥ 18.5 - 24.9
22.66 BMI ≥ 18.5 - 24.9
33.55 BMI ≥ 30 - 34.9
40.12 BMI ≥ 35
I have 5 'BMI Grouping' categories that I want to categorise the range of BMI into:
- BMI ≥ 18.5 - 24.9
- BMI ≥ 25 - 29.9
- BMI ≥ 30 - 34.9
- BMI ≥ 35
- BMI < 18.5
Please teach me the formula or code needed for Google Sheets.
Solution
you can use IFS with a combo of ARRAYFORMULA like:
=IFERROR(ARRAYFORMULA(
IFS(A2:A>=35, "BMI ≥ 35",
A2:A>=30, "BMI ≥ 30 - 34.9",
A2:A>=25, "BMI ≥ 25 - 29.9",
A2:A>=18.5, "BMI ≥ 18.5 - 24.9",
A2:A>=1, "BMI < 18.5")), )
- How to combine multiple conditions in a PowerShell if-statement
- I get an error when I end the if statement with a concluding else statement
- Does PHP have short-circuit evaluation?
- Why is this code still adding 1 to i even when the if statment that does so isnt called in C?
- error compiling in c user input
- R Conditional IfElse With Random Values
- Can not get past illogical line pep8 error
- smarty help with if statement
- 'if' must have both main and 'else' branches if used as an expression
- What is the standard for choosing "when" vs "if/else" in Kotlin?
- Python script continuously repeats the first if - else statement
- Why does python use 'else' after for and while loops?
- Use of ternary operator instead of if-else in C++
- Evaluate boolean environment variable in Python
- How to use if/else statement in terraform for loop
- change number grade to letter grade
- How to debug this substring matching code?
- If condition is getting skipped even if the condition is true
- Assign value to all rows based on condition being fulfilled or not
- Looping through a list in Python
- Why does if (fork() || fork() || fork()) behave differently?
- Python if not == vs if !=
- Discord.py | If statement not working correctly
- Angular 17 - In @if syntax, how to store returned value from a function in a variable and use it in the same @if block
- Angular: ng-content doesn't render with *ngIf then else
- How to get the next Bi-weekly date based on a given start date and today's date in Google Sheets
- What is the best way to refactor an if else branch
- Unreachable code in if-else structure
- Python if/else/elif
- Ternary conditional operator in Scala