Results 1 to 2 of 2

IF with multiple conditions

Threaded View

  1. #1
    Registered User
    Join Date
    05-04-2009
    Location
    DC
    MS-Off Ver
    Excel 2003
    Posts
    2

    IF with multiple conditions

    I sent the entire morning trying to figure this one out, it's time to recognize I need help
    I am trying to figure out how many client days we are accruing each month but I don't know how to include multiple conditions properly into my formula.

    F8 = whether a client stayed at a certain location or not.
    C$3 and B$3 are dates (first day of the month, last day of the month)
    K8 is the date the patient left (if he/she left during the month)
    IF F8=''','''' OTHERWISE IF C$3<K8>B$3, K8-C$3 OTHERWISE IF K8="", B$3-C$3

    I have attached the spreadsheet. Help!!

    thanks!

    Anne
    Attached Files Attached Files
    Last edited by AnneUSA; 06-23-2009 at 02:27 PM.

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