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

  • Thread starter Thread starter colinanthony
  • Start date Start date
C

colinanthony

I need to create an IF statement that returns false when encountered with
both blank cells and cells with text
 
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

IF statement to check for numerical value 3
Equation Efficiency? 1
#value error for sumproduct using RIGHT cmd 0
I want to create an IF statement that leaves a cell blank if.... 6
Multiple IF Statement 2
If Function 1
IF Statments in Excel 5
Difference between these two formulas? 5

Back
Top