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...
My guess it compares binary values, binary value of the text is always more than binary value of the number. For example =("1">1) returns TRUE since that's using binary value =(0011 0001 > 0000 0001). If i remember correctly what the binaries are...
And if you have any error in intermediate calculations of the formula final result gives that error code