Why doesn’t my IF statement work?

If you are getting an error in the Blockly Code around your IF statement, the first thing to check for is if the logic is sound. If it doesn't work the way it's intended in Excel, chances are it won't work in our platform either. 

However, if it does work in Excel the way it's intended, the second thing to check for is if there are any equations in the IF statement. Our platform doesn't yet support this so the best thing to do is to add the necessary number of rows above the IF statement so that the values that are being compared each have their own cell. Then each condition can compare the values of the cells above.

Here is an example of a valid IF formula that won't break on upload.