Why doesn't my IF statement work though it works in upload template?
Overview
The Excel IF statement is more flexible than Blockly, the math engine of the ValueCore platform.
Step-by-Step Guide
Even though the uploaded Excel function may not work, the function may be restated differently or broken into separate formulas to accomplish your calculation goal.
| A | B | |
| 1 | Doesn't work | Works |
| 2 | 22 | 22 |
| 3 | 32 | 32 |
| 4 | 55 | 55 |
| 5 | =if(A4<(A2+A3),1,0) | =B2+B3(54) |
| =if(B4<B5,1,0) |
| A | B | |
| 1 | Doesn't work | Works |
| 2 | 22 | 22 |
| 32 | 32 | |
| 55 | 55 | |
| =if(A2<A3,A2,A3)*A4 | =if(B2<B3),(A2*A4),(A3*A4)) |