1

A formula for < and >

Hi

I have a numeric value field and I would like to find the values smaller than 100 and bigger than 20

Can you tell me wich formula I should write ?

Thanks for your kind attention and advices.

Best regards,

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Nick
    • Nick
    • 2 yrs ago
    • Reported - view

    Create a formula field:

    ---

    if Amount >= 20 and Amount <= 100 then
    "Yes"
    end

    ---

    Like
    • Addinsell
    • Addinsell
    • 2 yrs ago
    • Reported - view

    Thank you Nick.

    Can you tell me where the formula box is ?

    I know the one that opens, when we click on the funnel icone since we select a field, but I know there is another one, the one you are talking about.

    Like
    • Addinsell
    • Addinsell
    • 2 yrs ago
    • Reported - view

    I think I found it.

    But I have an issue :

    4985BF4B-28FB-4106-8697-602EF3820815

    Like
    • Nick
    • Nick
    • 2 yrs ago
    • Reported - view

    Is your numeric field the 'Puiss'? If yes then:

    ---

    if Puiss >= 20 and Puiss <= 100 then
    "Yes"
    end

    ---

    Like
Like1 Follow
  • 1 Likes
  • 2 yrs agoLast active
  • 4Replies
  • 683Views