I would like to test for several conditions in a column and for each one have a different hard-coded output value. I can use an "If" statement for two output values (true and false), but is there a function that allows for more than two?
I tried the below with 'Switch' and it is generating an error due to the 'and':
=SWITCH(True(),[SchBegDiffNumber]>0 and [SchBegDiffNumber]<=5,5)
Is there another method that can evaluate values in a column and within the evaluation test for a high and a low value?
- Edited by Paul-NYS Thursday, August 14, 2014 7:52 PM