# Discussions

View Only

## If or Case formula for Calculation

• #### 1.  If or Case formula for Calculation

Posted 03-22-2019 19:17
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 :/

• #### 2.  RE: If or Case formula for Calculation

Posted 03-22-2019 19:22
You will need to use a normal If() condition versus case based on the fact that you're comparing a range of values.

Your syntax would be like:

if(
[Total Points Wk 1]<500,1,
[Total Points Wk 1]<1000,2,
[Total Points Wk 1]<1500,3,
4)

I'm assuming your syntax issue might be because you have your 1,2,3,4 in quotes like "1", "2".
Chayce Duncan | Technical Lead
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base

• #### 3.  RE: If or Case formula for Calculation

Posted 03-22-2019 22:13
Perfect! Thank you :)