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.

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.

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.

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.

.

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 -