IF Function

[sgrech]

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

[Cutter]

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.

[sgrech]

Thanks for that.

[Cutter]

You're welcome Simon.