HI,
I am not sure where my error is in the below switch statement. I keep getting the error on the subject line. Any and all help is appreciated.
Column = SWITCH (TRUE(),
AND ([# of Staffed Beds] >0,[# of Staffed Beds] <=24), "Less than 25",
AND ([# of Staffed Beds] >=25,[# of Staffed Beds]<=49),"25-49",
AND([# of Staffed Beds] >= 50, [# of Staffed Beds]) <= 99, "50-99",
AND ([# of Staffed Beds] >= 100, [# of Staffed Beds] <= 249), "100-249",
AND ([# of Staffed Beds] >= 250, [# of Staffed Beds]<= 499), "250-499",
AND ([# of Staffed Beds] >= 500,[# of Staffed Beds]<= 999), "500-999",
AND ([# of Staffed Beds] >=1000, [# of Staffed Beds]<= 9999999999999999999), "1,000+", BLANK(),
"Unknown")