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.

9 votes

New · Last Updated


Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!