- Log in to post comments
User bio
404 bio not found
Member since Mar 3, 2022
Posts:
Replies:
Now there is an issue. When a data field is 0, it does not read it as numeric.
Example, I have input values of 3.5 and 0 and want to subtract them, but I don't get output
Example, I have input values of 3.5 and 1 and want to subtract them, output is 2.5.
- Log in to post comments
As Emily Latella would say, "Never mind." I tried the $NUMBER function and it worked.
- Log in to post comments
Certifications & Credly badges:
Jonathan has no Certifications & Credly badges yet.
Followers:
Jonathan has no followers yet.
Following:
Jonathan has not followed anybody yet.
I figured it out with the ISVALIDNUM function, so all is good.