0

formula greater and less

Good morning.

I have a field called: "Artist Amount"
Example the amount in the field is 3200 euros
With a formula I wanted to make a nearby field with a generic amount for example
From 2000 to 4000
From 4000 to 7000
From 7000 to 1000 etc

So a field in which there is a formula that says:
If "Artist amount" is > (greater) than 2000 or < (less ) than 4000 then write "from 2000 to 4000"
If "Artist amount" is > (greater) than 4000 or < (less ) than 7000 then write "from 2000 to 7000"
If "Artist amount" is > (greater) than 7000 or < (less ) than 10000 then write "from 7000 to 10000"

How can I do?

Thank you.

2 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    You can use the switch() command. Try something like:

    switch true do
case 'Artist Amount' > 2000 and 'Artist Amount' < 4000:
"from 2000 to 4000"
case 'Artist Amount' > 4000 and 'Artist Amount' < 7000:
"from 4000 to 7000"
case 'Artist Amount' > 7000 and 'Artist Amount' < 10000:
"from 7000 to 10000"
end
    • John_Halls
    • 1 yr ago
    • Reported - view

    Don't for get to make one them equal to 2000, 4000 or 7000. An exact match of these values won't evaluate to anything.

Login to reply

Content aside

  • 1 yr agoLast active
  • 2Replies
  • 73Views
  • 3 Following