Problem with the ‘IF’ command

  • Resolved informativos

    (@informativos)


    4 months, 4 weeks ago

    Hi! I´m trying to make a resume of savings in a theoretically donation transaction but I´m been unable to do it.

    The formula is: 1-250 saves 80%
    and <250 is: first 250, 80% And the rest 40%

    For X <= 250€: X*0.8
    For X > 250€: (250*0.8) + (X-250)*0.4

    Any idea how to construct the ‘IF’ to work properly and as expected? formula/sentence?

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    4 months, 4 weeks ago

    Hello @informativos

    Your equation does not need an “if” conditional statement of the “IF” operation. You can implement the process with basic mathematical operations.

    Assuming the field for donation is the fieldname123. The equation in the calculated field can be implemented as follows:

    MIN(fieldname1, 250)*0.8+MAX(fieldname1-250, 0)*0.4

    Best regards.

    Thread Starter informativos

    (@informativos)

    4 months, 4 weeks ago

    Wow! It works!

    I can understand the commands very well but it works

    Thnks!!

    • This reply was modified 4 months, 4 weeks ago by informativos.
Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.

Tags