Forum Discussion
Excel If Functions
I created If function as shown in attached picture =if (c1>=10;2;0) then if I type a letter or text into c1 it show me the true value
Why excel understand that letter or text as number >=10
Why excel understand that letter or text as number >=10
10 Replies
In Excel with comparing operators any logical value is always more than any text, and any text is always more than any number.
- Thanks for your reply
But how I can fixed this I need to type text and the value not change or give me the value if falseSorry, I didn't catch. You type some text in c1 and compare it with 10. When you'd like to have TRUE and when FALSE, for which combination of text and 10?
