How do I write this logical argument?
in [Functions]
|
From: Matthew G Matthew on 7 Apr 2010 18:15 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.
From: Don Guillett on 7 Apr 2010 18:21 try =IF(AND(LEN(TRIM(a1))>0,ISNUMBER(a1)),1,2) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Matthew G" <Matthew G(a)discussions.microsoft.com> wrote in message news:471AA974-4C1E-4585-9E67-4553416C8D30(a)microsoft.com... > 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.
From: Pete_UK on 7 Apr 2010 18:22 Try these: =IF(ISNUMBER(A1), ... =IF(A1<>"", ... Hope this helps. Pete On Apr 7, 11:15 pm, Matthew G <Matthew G...(a)discussions.microsoft.com> 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.
From: Matthew G on 8 Apr 2010 14:22 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 G...(a)discussions.microsoft.com> > 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. > > . >
From: Pete_UK on 8 Apr 2010 18:54 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 <Matth...(a)discussions.microsoft.com> 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 G...(a)discussions.microsoft.com> > > 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 -
|
Pages: 1 Prev: Comparing Two Sheets Next: copy data from one sheet to another using a combo box |