Why does my formula work in Excel but not in upload?
Overview
The most likely reason that a formula works in Excel but not in upload is because it's not supported by Blockly. Refer the Formulas supported in the Excel Model to avoid errors..
Let's look at some of the reasons:
The logic supported is: equals ( = ), does not equal ( <> ), greater than ( > ), less than ( < ), greater than or equal to ( >= ), and less than or equal to ( <= ).
If any formula in the VROI_OUTPUTS sheet refers to a row below it, Blockly would never recognize it. Therefore, ensure that every formula in the VROI_OUTPUTS sheet only refers to rows above it and/or any variable from the VROI_INPUTS sheet.
- Ensure there are no unintended spaces (before or after strings and/or numbers) or alignments within cells.