+ Reply to Thread
Results 1 to 14 of 14

Help with Nested IF arguments, please

  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

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Help with Nested IF arguments, please

    Hello and welcome to the forum.

    Attach a sample workbook (not a picture or pasted copy).

    Make sure there is just enough data to demonstrate your need.

    Make sure your desired results are shown, mock them up manually if necessary.

    To upload an Excel workbook, follow these steps:
    1) Click on "Go Advanced"
    2) Click on "Manage Attachments"
    3) Click on "Choose File"
    4) Choose your file and click on "Open"
    5) Click on "Upload"
    6) Click on "Close this window"

  3. #3
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,100

    Re: Help with Nested IF arguments, please

    maybe something like this:
    =if(and(g2<>"",h2>f2),"Gone",if(and(g2<>"",or(h2<=f2,h2=""))"Await Collect",""))
    Click the * to say thanks.

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

    Re: Help with Nested IF arguments, please

    Oh Im in work and our IT department have diabled the attach facilty - sorry

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,102

    Re: Help with Nested IF arguments, please

    If you mean the paperclip, they haven't - it doesn't work. Your IT department would not be able to tamper with the way the forum works.

    To attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

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

    Re: Help with Nested IF arguments, please

    There - think its attached
    Attached Files Attached Files

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

    Re: Help with Nested IF arguments, please

    Quote Originally Posted by AliGW View Post
    If you mean the paperclip, they haven't - it doesn't work. Your IT department would not be able to tamper with the way the forum works.

    To attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Silly me, i was clicking on the wrong wrong attachment button

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,102

    Re: Help with Nested IF arguments, please

    Try this:

    =IF(AND(G3<>"",H3<>""),"Gone",IF(G3<>"","Await Collect",""))

  9. #9
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Help with Nested IF arguments, please

    Try this in N3:

    =CHOOSE(COUNT(G3:H3)+1,"","Await Collect","Gone")
    Last edited by 63falcondude; 07-12-2018 at 11:28 AM. Reason: Changed COUNTA to COUNT

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

    Re: Help with Nested IF arguments, please

    Quote Originally Posted by 63falcondude View Post
    Try this in N3:

    =CHOOSE(COUNT(G3:H3)+1,"","Await Collect","Gone")
    By Jove! You genius - thank you absolute millions

  11. #11
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Help with Nested IF arguments, please

    Happy to help. Thanks for the rep!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,102

    Re: Help with Nested IF arguments, please

    I think you'll find my formula works as well, although I think you might not have noticed it.

    Thanks for the rep and for marking the thread as solved.

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

    Re: Help with Nested IF arguments, please

    Oh I am so sorry for not noticing it....forgive me!
    Last edited by AliGW; 07-13-2018 at 04:22 AM.

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,102

    Re: Help with Nested IF arguments, please

    Just pointing it out so that you have an alternative approach.

+ 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. [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