I need conditional fomula to Ranges something like: If([Timesheet - Salario] < 787000 , 0) AND If([Timesheet - Salario] >787000, 5, [Timesheet - Salario] < 1181000 , 0 ?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I want to make ranges

Photo of Juan Camilo

Juan Camilo

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 410 Points 250 badge 2x thumb
In QuickBase formulas - there are short-hand ways of doing multiple If/Else statements:

e.g

If(
[Timesheet - Salario] > 0 and [Timesheet - Salario] < 787000, 0,[Timesheet - Salario] >= 787000 and [Timesheet - Salario] < 118100, 5,
[Timesheet - Salario] >= 118100, 10,
-1)
The last "-1" would be the "default" answer is none of the conditions in the If/Else statements are satisfied.
In this example - you have 3 ranges:  between 0 and 787000, between 787000 and 118100, and greater than 118100. 
If [Timesheet - Salario] doesn't fall into any of those ranges (e.g. it's a negative number) - then the formula returns -1 as the default..