try
=IF(AND(LEN(TRIM(a1))0,ISNUMBER(a1)),1,2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Matthew G" <Matthew wrote in message
...
What's the way to write in Excel "if cell A1 has a numeric value" or "if a
cell AI is not null"?

I'm using Excel 2007, and I'd like to make a formula that begins with that
condition, and goes on to have a string of other embedded functions.
Thanks
in advance.