Thanks Mike.

That did the trick for me.

"Mike H" wrote:

Maybe the ISNUMBER function

=IF(ISNUMBER(B1),"Number","Not a number")

Mike

"Toan" wrote:


Hello everyone :-)

I want to make a IF statement that looks at a cell and checks to see if that
cell is numerical value. What criteria can I use to check if it is a
numerical value? This has to be done within a IF statement.


For example

A B
1 B Null Value


So in the B1 cell, I want to have a statement like this....IF(A1 "does not
equal a numerical value", "Null Value", "")


A thousand thanks in advance :-)