+ Reply to Thread
Results 1 to 4 of 4

Multiple Argument for IF statement

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    North Carolina, United States
    MS-Off Ver
    Excel 2007
    Posts
    56

    Multiple Argument for IF statement

    I'm creating a workbook that uses algorithms. I'm creating the algorithms with IF statements (this is the only way I know how to perform them).

    Please see attached spreadsheet. I'm working on an IF statement that if the difference of D7 and C20 is 1 (cell B94 captures this total day)and the discharge disposition (D6) is either 4,6,or7 then it equals B217. I'm nesting the algorithm in cell M5.

    Also, could a formula/statment be made in B94 to say if cells D7 is blank then B94 is blank?

    Thanks for the help!
    Last edited by ExcelDummy77; 08-14-2014 at 03:51 PM.

  2. #2
    Registered User
    Join Date
    07-22-2014
    Location
    Riyadh
    MS-Off Ver
    2010
    Posts
    88

    Re: Multiple Argument for IF statement

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-04-2013
    Location
    North Carolina, United States
    MS-Off Ver
    Excel 2007
    Posts
    56

    Re: Multiple Argument for IF statement

    I've had trouble with the formula.

    I want M5 to have the formula (with the existing forumlas included there now). The Duration of Stay B94 will be hidden and I'd like to have the outcome "Discharge Disposition" to populate in the M5 cell.

    This is if the Arrival date and Discharge dates (D7 and C20) equal 1 day and the discharge dispositions (d6 dropbox) is either the answer of 4 Acute Care Facility, 6 Expired, 7 Left AMA.
    THanks!

  4. #4
    Registered User
    Join Date
    07-22-2014
    Location
    Riyadh
    MS-Off Ver
    2010
    Posts
    88

    Re: Multiple Argument for IF statement

    please check now...

    thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IF Statement for copying multiple cells if argument true
    By saeed9313 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2012, 01:44 AM
  2. Using a Boolean function within an If statement: Argument not optional error message
    By elfsprin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-16-2011, 04:12 PM
  3. selecting first correct argument in if statement
    By gss in forum Excel General
    Replies: 4
    Last Post: 06-09-2009, 02:27 AM
  4. Using first correct argument in if statement
    By gss in forum Excel General
    Replies: 5
    Last Post: 06-03-2009, 04:23 PM
  5. [SOLVED] Function (array argument, range argument, string argument) vba
    By Witek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2005, 11:07 AM

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