Formula Question

Discussion in 'Microsoft Certification' started by =?Utf-8?B?R0c=?=, Mar 15, 2006.

  1. I want to setup a formula that compares two cells that are date fields and I
    want the output to say "problem " if the date in cell Q2 is greater than
    L2 instead of True or false .
    My formula look like this.
    =IF(Q2>L2,problem)
     
    =?Utf-8?B?R0c=?=, Mar 15, 2006
    #1
    1. Advertising

  2. you need to add a response if the condition is false e.g =IF(Q2>L2,problem,no
    problem)
    --
    "Twice and twice shall he be marked,
    twice to live and twice to die.
    Once the heron, to set his path.
    Twice the heron, to name him true."


    "GG" wrote:

    > I want to setup a formula that compares two cells that are date fields and I
    > want the output to say "problem " if the date in cell Q2 is greater than
    > L2 instead of True or false .
    > My formula look like this.
    > =IF(Q2>L2,problem)
     
    =?Utf-8?B?RHJhZ29uIFJlYm9ybg==?=, Apr 28, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Doug

    Excel 2003 Formula

    Doug, Feb 15, 2004, in forum: Microsoft Certification
    Replies:
    0
    Views:
    564
  2. =?Utf-8?B?QyBBbmRlcnNvbg==?=

    Excel Formula

    =?Utf-8?B?QyBBbmRlcnNvbg==?=, Apr 12, 2006, in forum: Microsoft Certification
    Replies:
    1
    Views:
    582
    Carey Frisch [MVP]
    Apr 12, 2006
  3. Katherine Colby

    -Excel Formula Question

    Katherine Colby, Jan 12, 2004, in forum: Computer Support
    Replies:
    3
    Views:
    602
  4. M D
    Replies:
    10
    Views:
    1,964
  5. VertiCody

    Excel Formula Question

    VertiCody, Oct 27, 2008, in forum: Microsoft Certification
    Replies:
    0
    Views:
    484
    VertiCody
    Oct 27, 2008
Loading...

Share This Page