Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Expression with between

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 Solved
0 2 130
1 ACCEPTED SOLUTION

2 REPLIES 2

Thank worked, thank you so much again!

Top Labels in this Space