IF statement to check for numerical value
 

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 :-)

IF statement to check for numerical value
 

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 :-)

IF statement to check for numerical value
 

One way:

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

--
Biff
Microsoft Excel MVP


"Toan" wrote in message
...

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 :-)

IF statement to check for numerical value
 

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 :-)