Results 1 to 4 of 4

Multiple IF statements & Multiple Results

Threaded View

  1. #1
    Registered User
    Join Date
    08-06-2012
    Location
    Bristol
    MS-Off Ver
    Excel 2007
    Posts
    62

    Multiple IF statements & Multiple Results

    Hi,
    I need help with a formula.

    =IF($O5<>"Complete",IF(AND($S5<$B$1,$S5>=DATE(2012,10,1),$R5<=DATE(2012,10,31)),"Late"," "))*IF($O5="Running",IF(AND($B$1<=DATE(2012,10,31)),"OT",""))

    This is what I have, and it currently just returns #Value.
    Cell O5 contains various statuses.
    Cell S5 contains a start date, R5 a completion date and B1 todays date.

    Both formulas work on there own i.e.
    =IF($O5<>"Complete",IF(AND($S5<$B$1,$S5>=DATE(2012,10,1),$R5<=DATE(2012,10,31)),"Late"," "))

    And
    IF($O5="Running On Time",IF(AND($B$1<=DATE(2012,10,31)),"OT",""))

    But I would like them to both work for one cell.

    Any ideas?
    Cheers
    Last edited by Will_iam; 10-18-2012 at 06:48 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1