How do I write this logical argument?

M

Matthew G

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.
 
M

Matthew G

Your help provided my solution. Thanks. Do you know where can I find a list
of those terms?
 
P

Pete_UK

You're welcome, Matthew - thanks for feeding back.

You can find more details about ISNUMBER (and other IS functions) in
Excel Help.

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

Logical formatting for multiple values 1
Ms Excel Multiple Logical Test Function 0
Excel functions 0
Returning 1 of 4 values if conditions are met 4
A complex formula, help needed 2
Logical Test 2
Return result of IF logical test in a different cell 1
function to populate a cell where formula is NOT located 6

Top