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
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?
- When I type text in C1 it give me the value if false in D1 not the value if true
