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
Perhaps
=IF(ISNUMBER(C1)*(C1>=10),2,0)
if I understood your logic correctly. Please see in attached file.
Yes thanks for your cooperation