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

[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

 

[muddan madhu]

=if(istext(d3),1,0) & =if(isnumber(d3),1,0)

 

[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