Can i create an IF statement that looks for just numeric values?
 

I need to create an IF statement that returns false when encountered with
both blank cells and cells with text

Can i create an IF statement that looks for just numeric values?
 

If you want to test A1, then try this:

=ISNUMBER(A1)

adjust the cell reference to suit.

Hope this helps.

Pete


On Mar 25, 7:06*pm, colinanthony
wrote:
I need to create an IF statement that returns false when encountered with
both blank cells and cells with text