Results 1 to 6 of 6

Nest If Statements Dependent on Multiple Cells

Threaded View

shanafesta Nest If Statements Dependent... 03-21-2015, 09:36 PM
Moo the Dog Re: Nest If Statements... 03-21-2015, 10:31 PM
FDibbins Re: Nest If Statements... 03-21-2015, 10:42 PM
shanafesta Re: Nest If Statements... 03-22-2015, 12:07 AM
shanafesta Re: Nest If Statements... 03-22-2015, 12:10 AM
FDibbins Re: Nest If Statements... 03-22-2015, 12:12 AM
  1. #1
    Registered User
    Join Date
    03-21-2015
    Location
    United States
    MS-Off Ver
    2013
    Posts
    3

    Exclamation Nest If Statements Dependent on Multiple Cells

    Could someone give me the right formula for this? I cant seem to make nested IF statements work right and my experience with formulas is minimal. (Coding nonexistent)

    I have 4 columns in which dates are entered. I have a fifth column for "Status".

    SO I would like a formula that says:
    If A1 has a value (date) then E1="Requested".
    But if B1 has a value then ignore A1 statement and E1="Accepted".
    But if C1 has a value then ignore A1 & B1 statements and E1="Rejected".
    But if D1 has a value then ignore A1, B1 & C1 statements and E1="Completed".
    And if no value in A1:D1 then E1=(blank cell)

    (A1) Requested
    (B1) Accepted
    (C1) Rejected
    (D1) Completed
    (E1) Status

    The columns in the attached spreadsheet to correspond with the above are K,L,M,N (A-D) and J (E)
    Attached Files Attached Files
    Last edited by shanafesta; 03-21-2015 at 09:54 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Can I nest Countifs Statements in an IF / OR statement?
    By CWatsonJr in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-02-2013, 04:13 PM
  2. [SOLVED] Can I nest IF statements, if the first one is checking for data?
    By Barnaclebot in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-15-2013, 03:25 PM
  3. [SOLVED] How to nest two IF statements
    By wolfgang713 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-15-2013, 09:50 AM
  4. Nest Lookup With If And Statements
    By opeyemi1 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 02-19-2008, 11:57 AM
  5. How do I nest IF statements to only return value if both true?
    By kvnexcel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-14-2006, 01:40 PM

Tags for this Thread

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