ISNUMBER function
There is currently no way no easy way to identify whether data is numeric or not. The workaround for X is to check the following set of conditions:
NOT (VALUE(X) <= 0 OR VALUE(X) >= 0)
Currently this is certainly not a consistent approach and there is always a risk that the comparison operators ("<=" and ">=") will start behaving differently which will lead to errors.
Tagged:
9
Comments
-
Status changed to: New0
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!