Thanks for your quick response.

W. Wolfe


"Rick Rothstein" wrote in message
...
Use the ISNUMBER function...

=IF(A1="","I'm blank",IF(ISNUMBER(A1),"I'm a number","I'm text"))

--
Rick (MVP - Excel)


"William Wolfe" wrote in message
...
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