I am writing data to Excel sheet, but it gets “NaN” value.
I am wanting to somehow check this value using if activity, but I haven’t been able to. I am writing to file using Write Range.
This data initially comes from another Excel sheet, and it is a number.
I tried the following but it never caught it.
if myValue.ToString Is Nothing
if myValue.ToString.Trim Is “NaN”
I want the evaluation to be TRUE, but it is returning false… how can I get the right condition to handle “NaN” value?