[ad_1]
Hello @rphrus,
Thank you very much for using our plugin.
Your equation can be implemented as follows:
IF(50<fieldname1+30, 20-fieldname1, fieldname1+30)Note you said subtract the calculated value from 50. So, the second parameters is 20-fieldname1 because:
50 – (fieldname1+30) = 50 – fieldname1 – 30 = 20 – fieldname1
If you want to subtract 50 from the calculated value, the equation would be:
IF(50<fieldname1+30, fieldname1-20, fieldname1+30)In this case, the second parameter is: (fieldname1+30)-50 = fieldname1-20
Best regards.