IF statement to check for numerical value

[Toan]

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

 

[Mike H]

Maybe the ISNUMBER function

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

Mike

 

[T. Valko]

One way:

=IF(COUNT(A1),"Yes","No")

 

[Toan]

Thanks Mike.

That did the trick for me.

Maybe the ISNUMBER function

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

Mike