How to change data from a "number" to text?

[Eloise T]

See attached Excel file and formula segment:

IF(H9<L9,"$ H"&ROW()&" ≠ $ L"&ROW()&" Tech is undercharging.",

I have an Excel file that appears to be translating a "check mark" (√) (technically U+221A which is the square root symbol) in cell L9 into a number as it is assessing the check mark as being "larger" than any number I compare it to in cell H9. Please see attachment. The check marks in L9 and O9 are there to flag/warn something is wrong. How can I force the comparison in K9 to see the check mark as text and not a number?

 

[Chihiro]

Actually, that's standard behavior of ">" operator.

Any text is considered larger than number.

Just add additional condition that L9 is number in your if statement.
IF(AND(H9<L9, ISNUMBER(L9)),

 

[Eloise T]

Thank you! I will give it at try.




ET
---------------------------------------------------------------------------------------------

"Perseverance is failing 19 times requesting an upgrade and succeeding anyway using Excel 2007."- Eloise T.

(Still using Excel 2007)