Results 1 to 14 of 14

Help with Nested IF arguments, please

Threaded View

  1. #1
    Registered User
    Join Date
    07-12-2018
    Location
    Bolton UK
    MS-Off Ver
    2010 plus
    Posts
    11

    Help with Nested IF arguments, please

    Hi Everyone

    I hope you can help - Im trying to figure the correct formula and being a slight Excel obsessive with basic formula understanding, im in a pickle!

    I want my master Cell (in column N) to write a status based on the entry of a date (any date) of column G to read "Await Collect"

    BUT

    If column H has a date (any date, always greater than the date in Column F) I want it to read "Gone"

    Ive really tried searching under IF with ANY or OR in the argument but my head is mashed.

    Your expertise and advice is very much appreciated.
    Attached Files Attached Files
    Last edited by KWiseman; 07-12-2018 at 11:21 AM. Reason: to add attachment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Nested IF AND giving a too many arguments error
    By rlh in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-25-2017, 07:59 PM
  2. Too many arguments in nested if function
    By floridashaughn in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2014, 02:23 PM
  3. I am having an issue with an IF formula that contains 4 nested arguments....
    By iamjustinpowell in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-22-2013, 04:00 PM
  4. [SOLVED] nested if formula claims there are too many arguments
    By asthx in forum Excel General
    Replies: 3
    Last Post: 02-11-2013, 01:49 AM
  5. Need a Nested IF with 12 Arguments
    By daz_uk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-29-2010, 08:54 AM
  6. Going beyond 7 Nested If Arguments
    By Supdem in forum Excel General
    Replies: 2
    Last Post: 08-05-2009, 03:06 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