Forum Discussion
Issues in Comparison Formulas
Do any of you can explain the following issues? ="text">1 (or any other number) Result: TRUE ="text"<1 (or any other number) Result: FALSE =#N/A=1 In this case, the formula will ret...
Any error that is not trapped in a formula, for example with an IfError() function or similar, will pass on the error to the formula result. That is expected behaviour, since the idea is that you'd want to troubleshoot and remove errors, or at least be alerted to errors.
Re comparing text to numbers: Excel sorts text after numbers, so any text will always be regarded greater than any number. You can test that. Enter a mix of text and numbers into a range and then sort the range.
cheers, teylyn