What is the appropriate way to handle displaying a specific result if a value is between two numbers? Can this be done properly through formula and not relying on the visual filters?
I was thinking something along the lines of SWITCH TRUE()
Example: If a students CGPA is between 3.0 and 3.30 I want it to return or say "Standard Academic Performance.
But would it be:
CGPA Status =
SWITCH(
TRUE(),
[CGPA] >=3.00 || [CGPA] >= 3.30, “Standard Academic Performance”,
[CGPA] <=3.30 || [CGPA] <= 3.60, “Above Standard Academic Performance”
)
The problem with something like the above is it does not confine the results so that its greater or equal to 3.00 but less than or equal to 3.30 to return that result.
