| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I write this logical argument?
What's the way to write in Excel "if cell A1 has a numeric value" or "if a
cell AI is not null"? I'm using Excel 2007, and I'd like to make a formula that begins with that condition, and goes on to have a string of other embedded functions. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I write this logical argument?
try =IF(AND(LEN(TRIM(a1))0,ISNUMBER(a1)),1,2) -- Don Guillett Microsoft MVP Excel SalesAid Software "Matthew G" <Matthew wrote in message ... What's the way to write in Excel "if cell A1 has a numeric value" or "if a cell AI is not null"? I'm using Excel 2007, and I'd like to make a formula that begins with that condition, and goes on to have a string of other embedded functions. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I write this logical argument?
Try these:
=IF(ISNUMBER(A1), ... =IF(A1<"", ... Hope this helps. Pete On Apr 7, 11:15*pm, Matthew G <Matthew wrote: What's the way to write in Excel "if cell A1 has a numeric value" or "if a cell AI is not null"? I'm using Excel 2007, and I'd like to make a formula that begins with that condition, and goes on to have a string of other embedded functions. *Thanks in advance. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I write this logical argument?
Your help provided my solution. Thanks. Do you know where can I find a list
of those terms? "Pete_UK" wrote: Try these: =IF(ISNUMBER(A1), ... =IF(A1<"", ... Hope this helps. Pete On Apr 7, 11:15 pm, Matthew G <Matthew wrote: What's the way to write in Excel "if cell A1 has a numeric value" or "if a cell AI is not null"? I'm using Excel 2007, and I'd like to make a formula that begins with that condition, and goes on to have a string of other embedded functions. Thanks in advance. . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I write this logical argument?
You're welcome, Matthew - thanks for feeding back.
You can find more details about ISNUMBER (and other IS functions) in Excel Help. Pete On Apr 8, 7:22*pm, Matthew G wrote: Your help provided my solution. *Thanks. *Do you know where can I find a list of those terms? "Pete_UK" wrote: Try these: =IF(ISNUMBER(A1), ... =IF(A1<"", ... Hope this helps. Pete On Apr 7, 11:15 pm, Matthew G <Matthew wrote: What's the way to write in Excel "if cell A1 has a numeric value" or "if a cell AI is not null"? I'm using Excel 2007, and I'd like to make a formula that begins with that condition, and goes on to have a string of other embedded functions. *Thanks in advance. .- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help!!! - logical function for someone not very logical | Excel Worksheet Functions | |||
| How do I write an If(And( function using dates as my logical test? | Excel Worksheet Functions | |||
| Excel interprets Text String as value in logical Argument | New Users to Excel | |||
| how to use "if" logical argument to format/copy some pic. in cell | Excel Worksheet Functions | |||
| How can I write a formula or an argument to highlight a date when. | Excel Worksheet Functions | |||
Linear Mode
