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
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 false
But how I can fixed this I need to type text and the value not change or give me the value if false
Sorry, 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?