| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ISNUMBER
Hi
I want to be able to check two cells at once to see if they contain a number and then do a calculation based on whether they do or don't. The problem is the ISNUMBER function does not seem to be able to check two cells at once. Is there any way around this? Thanks Michael |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
ISNUMBER
Michael Nol wrote...
I want to be able to check two cells at once to see if they contain a number and then do a calculation based on whether they do or don't. The problem is the ISNUMBER function does not seem to be able to check two cells at once. Is there any way around this? COUNT(OneCell,AnotherCell)=2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting a Function not defined in VBA editor for IsNumber() | Excel Discussion (Misc queries) | |||
| isnumber multiple criteria. | Excel Worksheet Functions | |||
| ISNUMBER and VLOOKUP Help Needed | Excel Worksheet Functions | |||
| Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
| array functions and ISNUMBER() | Excel Worksheet Functions | |||
Linear Mode
