I have a IFS statement that I want to categorize some GPA, I am having trouble with the code to return the category for between 2 numbers. Here is my code
IFS (
([TGPA] >= 4),"4.0 +",
([TGPA] >= 3, [TGPA] < 4 ),"3.0 to 3.99",
)
I would like to know the correct way of categorizing the range, Any thoughts?
Solved! Go to Solution.
Thank worked, thank you so much again!
User | Count |
---|---|
15 | |
12 | |
9 | |
8 | |
4 |