Results 1 to 5 of 5

Multiple IF THEN ELSE statements from two cells

Threaded View

  1. #1
    Registered User
    Join Date
    07-19-2014
    Location
    Seattle, WA
    MS-Off Ver
    Excel MAC 2011
    Posts
    13

    Multiple IF THEN ELSE statements from two cells

    EDIT, the title should say multiple cells, not two cells.

    Hello,

    I need help with a massive IF THEN ELSE situations, I've done a max of two IF THEN ELSE statements but nothing this massive and I'm beginning to think it just can't be done except manually.

    I've attached a weight example spreadsheet. There are five columns, Starting Weight, Mid point weight, Midpoint weight part 2, ending weight and what I need to figure out are the Next Actions, which is the last column.

    Here are the scenarios, which need to go in order from First to Last:
    1. If starting weight is greater than or equal to 200 and end weight is greater than or equal to 200, this should be labeled as One on One
    2. If ending weight is greater than or equal to 200, this should be labeled as Conference Call
    3. If ending weight is greater than starting weight, this should be labeled as Examine
    4. If ending weight is starting weight, this should be labeled as Home Visit
    5. If Midpoint weight is greater than or equal to midpoint weight part 2, this should be labeled as Examine Mid Checkpoint
    6. If there is a decrease in the Midpoint Weight and Midpoint Weight Part 2, this should be labeled as Examine Mid Trainer

    Is this possible? Thank you in advance for any help that you can provide!
    Attached Files Attached Files
    Last edited by wizzard21; 07-20-2014 at 12:12 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple if Statements for multiple cells.
    By fplated in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-23-2013, 05:32 PM
  2. Replies: 0
    Last Post: 09-04-2009, 07:58 AM
  3. Replies: 12
    Last Post: 05-15-2009, 08:38 AM
  4. Add multiple IF statements to a combined string of cells
    By littledobby in forum Excel General
    Replies: 1
    Last Post: 07-17-2008, 11:31 PM
  5. Multiple IF statements and conditional locking of cells
    By MrSandman in forum Excel General
    Replies: 3
    Last Post: 02-08-2008, 01:26 PM

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