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

C

colinanthony

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

Pete_UK

If you want to test A1, then try this:

=ISNUMBER(A1)

adjust the cell reference to suit.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
VBA Export to PDF 0
Multiple IF Statement 2
IF statement to check for numerical value 3
If statement checking list 4
Index Match & #values 0
MS Word normal.dot cannot be fixed 'text box' appears each time 4
VBA to look for more than 1 key word and highlights 8

Top