IF formula and data range

[miki2024]

Hello,

I'm trying to categorize the number of students into three buckets based on their eye sight.

S = from > 10 to 20

M = from >20 to 30

L= from >50

IF [Count of students]>10 THEN "S"
ELSEIF [Count of students]>20 THEN "M"
ELSEIF [Count of students]>50 THEN "L"
ELSE "N/A" ENDIF

When I run the results, I cannot capture the M and L using the above formula. Wonder if I miss anything?

[DataNath · Accepted solution]

Hey @miki2024, if you reverse your conditions then that should help i.e. have the >50 first, then >20 and then finally >10. Also, not sure if it's a typo but your current 'M' condition will cover 20-50, not 20-30 as you stated at first.

IF [Count of students]>50 THEN "L"
ELSEIF [Count of students]>20 THEN "M"
ELSEIF [Count of students]>10 THEN "S"
ELSE "N/A" ENDIF