Switch case to check range of number

Help
8

Yah we can use this expression in switch expression as input
IF (Convert.ToDouble(in_amount) > 1, “Greater than 1
IF(Convert.ToDouble(in_amount) < 5000, “Lesser than 5000”,
IF(Convert.ToDouble(in_amount) > 5000, “Greater than 5000”,
IF(Convert.ToDouble(in_amount) < 10000,”Lesser than 10000”,
IF(Convert.ToDouble(in_amount) > 10000,”Greater than 10000”,
“Less than 1”)))))

And mention the string mentioned above in the cases as value like Greater than 1 for case1, Lesser than 500 for case2… it goes on

Hope this would help you
Cheers @sarathi125

3 Likes