IF Function
 

Hi,
I want to use an IF function to examine the contents of a cell and if
the cells contains a numeric value then do something else do something
else. How do I check if something is numeric?

Thanks
Simon


--
sgrech
------------------------------------------------------------------------
sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501
View this thread: http://www.excelforum.com/showthread...hreadid=466914

Use the ISNUMBER() function within your IF() function.

Like this:

=IF(ISNUMBER(A1),A1,"")

This will result in the value of A1 if it's numeric but blank ("") if
it's not.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=466914

Thanks for that.


--
sgrech
------------------------------------------------------------------------
sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501
View this thread: http://www.excelforum.com/showthread...hreadid=466914

You're welcome Simon.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=466914