Help - The formula ="">60 return True. Why?

[jaiprakashsingh]

Greetings to all.
I am working on building some reporting models. I came across a problem that seems simple but I cant seem to understand the root cause.
Please help me with it.

Open a blank excel.
In cell A1, type the formula ="">60. I expect excel to return false, but it return TRUE.. I dont know why?

Help me as soon as possible.

Thank you in advance.

 

[bhos123]

="">"60"

 

[wideboydixon]

You're comparing a string and a number. Who's to say which is greater? You'll need to check whether your comparison value is empty before calculating the result.

=IF(""="",FALSE,"">60)

WBD

 

[RoryA]

It is simply because all text (including zero length strings) is treated as being larger than all numbers in Excel.