I know that I can do this relatively easy with an if statement. But I am guessing that I can also do it with a Switch to make it relatively easier. I am just having trouble with the syntax I think.
Number |
3 |
6 |
9 |
Switch([Number], " Greater than 9 ", < 3, " < 3", <= 6, " <= 6", <= 9, "<=9")
Thanks in advance. If I have to type the field [Number] before each operator then what's the point of switch?
I am afaid that we may not.
According the help, we can not really use any formula or statement as criteria.
The Else if should be considered.
You can do what you are trying to do with a switch - but you need to think about "how do I make my comparison versus a finite value?" In your case:
Number |
3 |
6 |
9 |
Switch([Number], " Greater than 9 ", < 3, " < 3", <= 6, " <= 6", <= 9, "<=9")
Can be re-written as:
switch(floor(([Number ]-1)/3)+1,">9",1,"<=3",2,"<=6",3,"<=9")
This is the floor division of your number -1 by 3 then with 1 added (so your base case is 1.) Subtracting 1 from your number transforms the number which is divisible by 3 from being the smallest entry in the new set to the largest entry in the previous set.