| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I ADD NON-NUMERIC VALUES | New Users to Excel | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Return Numeric Labels that have different Numeric Values | Excel Worksheet Functions | |||
| Non Numeric Values | Charts and Charting in Excel | |||
| Text values to numeric values | Excel Discussion (Misc queries) | |||
Hybrid Mode
