Defining if a cell has an letter / number with in it using IFstate

W

Washeacrim

In a IF statement how do i determine a letter or a number within a cell using
Excel 2007

ie IF(D3 = letter; then 1 ; else 0)

Thanks
 
B

Bernard Liengme

=IF(ISNUMBER(D3), "It's a number", "It's text or Boolean")
=IF(ISNUMBER(D3), 1,0)

But the IF is not needed when you want just 1 or 0
=--ISNUMBER(D3)
The double unary negation converts Boolean TRUE/FALSE to numeric 1/0

best wishes
 
Top