Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: IF Statements

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can anyone help me with this problem?
    I am trying to put together an "IF" statement which says:

    If the due date is < today's date = Late

    If the due date is = today's date = Due

    If the due date is less 2 days than today's date = AT RISK

    Otherwise = Pending

    The IF statement I tried to put together, is correct all the way up to "AT RISK". Can anyone tell me how to do 2 days less.

    F4 = Due Date
    F2 = Today's date

    Your help would be greatly appreciated!!

    Thanks!




    [ This Message was edited by: christal on 2002-05-09 11:40 ]

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try:

    "=IF(F4TODAY(),F4
    _________________
    It's never too late to learn something new.

    Ricky

    [ This Message was edited by: Ricky Morris on 2002-05-09 11:47 ]

  3. #3
    New Member
    Join Date
    May 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Maybe there's a shorter way to do this, but here's one solution:

    IF(F4< F2,"Late",IF(F4=F2,"Due",IF(F4=(F2+1),"At Risk",IF(F4=(F2+2),"At Risk","Pending"))))

    [ This Message was edited by: phillycarol on 2002-05-09 11:48 ]

    [ This Message was edited by: phillycarol on 2002-05-09 11:49 ]

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =VLOOKUP(F4-TODAY(),{-9E+307,"Late";0,"Due";1,"AT RISK";2,"Pending"},2)

    I'm a little uncertain of your "AT RISK" definition. Let me know if I need to refine my formula to fit your needs.

    [ This Message was edited by: Mark W. on 2002-05-09 12:04 ]

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Philly Carol.....

    Thanks! It worked perfect!!!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •