I have a quality control script that examines a large spreadsheet for values out of specification. It is not working for certain number types that seem to be decimals. When I check with the following simplified script it works for integers but not for values less than 1. For example:
Value1 = 10 Value2 = 20. Result = 10 - 20 (-10)
If Result <0 type “Neg”
This works fine. If however the values are
Value1 = 0.1 Value2 = 0.2 then the “If” condition does not execute and even though I can see the calculation has worked the “Neg” does not get typed.
Is this a known bug? Below is the execution path for the fraction numbers.