If or Case formula for Calculation
I am trying to create a formula field with these guidelines:
If or Case ([Total Points Wk 1] is less than 500, return value "0", 500-999 return value "1", 1000-1499 return value "2", 1500+ return value "3") Once I have a functioning formula field that gives me those 4 results (0,1,2,3) I will have to replicate it for [Total Points for Wk 2], and Wk 3 and 4 and so on... When I try the traditional set up of these functions I get errors for expecting text or number or bool :/
If or Case ([Total Points Wk 1] is less than 500, return value "0", 500-999 return value "1", 1000-1499 return value "2", 1500+ return value "3") Once I have a functioning formula field that gives me those 4 results (0,1,2,3) I will have to replicate it for [Total Points for Wk 2], and Wk 3 and 4 and so on... When I try the traditional set up of these functions I get errors for expecting text or number or bool :/
