Variable Result from a Slider

Hello @graicifyd

You cannot pas more than three parameters to the “IF” operation,
because the structure of the “IF” operation is:

IF(condition, result if condition true, resut if condition false)

Put you can nesting multiple “IF” operations.

The following equation is hypothetical because you don’t have described the operations in case fieldname1 be over 50000:

IF(fieldname1<10000, fieldname1*2,IF(fieldname1<50000, 10000*2 + (fieldname1-10000)*3,  10000*2 + 50000*3 + (fieldname1-50000)*3))

However, in cases similar to yours would be easier to understand, using function structure with “if” conditional statements instead “IF” operations:

(function(){
if(fieldname1<10000) return fieldname1*2;
if(fieldname1<50000) return 10000*2 + (fieldname1-10000)*3;
return  10000*2 + 50000*3 + (fieldname1-50000)*3;
})()

Best regards.

Hello @graicifyd

Please read the structure of the IF operation, I described it in the previous entry, you are using it with a wrong structure again.

If you want to check for a value into a range, you should to compare with both corners but using the AND operation or the and operator &&

AND(10000<fieldname1, fieldname1<50000)

or

10000<fieldname1 && fieldname1<50000

Best regards.