Formula

  • Resolved simplypw

    (@simplypw)


    9 years, 9 months ago

    Would you be able to help with a formula that will return a value from a range of numbers i.e.

    if there are 2 ranges 1 – 10 and 11 – 20 and 1 – 10 == value 1 and 11 – 20 = value 2

    What would the formula be if I wanted to look up in my calculation a value of 12 and need to return the value of 2 which would be the result from that range.

    https://wordpress.org/plugins/calculated-fields-form/

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    9 years, 9 months ago

    Hi,

    I will give you an example of eqution with comparisons.

    (function(){
    if(1<=fieldname1 && fieldname1 <=10) return fieldname2;
    if(11<=fieldname1 && fieldname1 <=20) return fieldname3;
    })()

    Replace the field names with the corresponding fields of your form.

    Note: You can hire our services to create your formulas.

    Kind regards.

Viewing 1 replies (of 1 total)
  • The topic ‘Formula’ is closed to new replies.