Forum Discussion

Mfouad2255's avatar
Mfouad2255
Copper Contributor
Jun 08, 2019

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
if
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 08, 2019

Mfouad2255 ,

 

In Excel with comparing operators any logical value is always more than any text, and any text is always more than any number.