LinkBack URL
About LinkBacks
In cell A1 I have the formula =""
In cell A2 I have the formula =(A1>2)
Cell A2 returns TRUE
How is this possible?
Inequality Incorrect?
In cell A1 I have the formula =""
In cell A2 I have the formula =(A1>2)
Cell A2 returns TRUE
How is this possible?
Last edited by SDruley; 02-12-2011 at 01:03 PM.
Turn Data into Information
Turn Information into Knowledge
Turn Knowledge into Direction
Turn Direction into Leadership
Turn Leadership into Results
Stephen Druley
It's not how quickly you think
But how deeply you think
The quality of thinking is measured
by remoteness to conformance
Stephen Druley
Because ="" is not the same as an empty cell. If you delete it, the formula in A2 will return FALSE.
What are you trying to achieve?
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
A Formula Null is a 0 Length Text String and Text > Number.Originally Posted by SDruley
For a numeric comparison where Nulls/Text values are a possibility you can use N or SUM, eg:
which will return 0 for the Null/Text value whilst avoiding explicit coercion
=N(A1)>2 =SUM(A1)>2
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Re: Inequality Incorrect?
There is so much talent in this forum it is unbelievable.
Thank you both for your expertise and a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks