Hello,

We have managed to get IF statements to work in Excel, and with successful import to the Calculator.

However, calculations inside an IF statement do not seem to work (but they work fine in Excel).

example…

We have a List input (D2 Excel field) like so:

a [Value: 0]

b [Value: 0]

c [Value: 0]

d [Value: 0.002]

Then we calculate price with this formula: =IF(D2=0.002,0.2*E2,0)

It works in Excel just fine. But in your Calculator, the 0.2*E2 part is not executed.

It works fine in your Calculator, if we put fixed values e.g. =IF(D2=0.002,100,0)

Any idea? Thanks