Hi,

Try this

=IF(ISNUMBER(A1),"Do number things",IF(NOT(ISBLANK(A1)),"Do text things","Do
neither, it's blank"))

Mike

"William Wolfe" wrote:

I need to write an IF statement so that if the contents of a cell are a
letter do one thing, it they are a number do another.

How do I distinguish between the two in an IF statement?

Thanks,

W. Wolfe