+ Reply to Thread
Results 1 to 8 of 8

Nested IF - too many arguments

  1. #1
    Registered User
    Join Date
    04-02-2019
    Location
    Ottawa,Ontario
    MS-Off Ver
    2007
    Posts
    87

    Nested IF - too many arguments

    Not sure what I am doing wrong,

    =IF(B9="both","1:00",IF(B9="SpareCall","0:30"),IF(B9="930","0:30"))

    can anyone help me on this ?

    its in the test sheet tab
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,747

    Re: Nested IF - too many arguments

    Untested, but try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,747

    Re: Nested IF - too many arguments

    Probably needs to be
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    But note that the output(s) will be Text, not true Time values.

  4. #4
    Registered User
    Join Date
    04-02-2019
    Location
    Ottawa,Ontario
    MS-Off Ver
    2007
    Posts
    87

    Re: Nested IF - too many arguments

    it works.

    1 more question. I need to be able to manually add minutes to the total of k3.

    kicker, is it possible to just add 1 number and it be converted to time ?

    a10 - header - Addition HOS Minutes
    a11 - 7 - would really just like to add 1 digit instead of 0007
    a12 - converted result in hh:mm format so I can sum it with the total in k3
    Last edited by northernwarrior; 04-08-2022 at 06:33 PM.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,747

    Re: Nested IF - too many arguments

    Something like:
    =K3+TIME(0,1,0)
    =K3+TIMEVALUE("00:01:00")

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,747

    Re: Nested IF - too many arguments

    Or:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    where K1 contains a number (of minutes).

  7. #7
    Registered User
    Join Date
    04-02-2019
    Location
    Ottawa,Ontario
    MS-Off Ver
    2007
    Posts
    87

    Re: Nested IF - too many arguments

    Quote Originally Posted by TMS View Post
    Or:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    where K1 contains a number (of minutes).
    Hot Damn ! that worked and wow so easy. thank you very much !!!!!

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,747

    Re: Nested IF - too many arguments

    You're welcome. Thanks for the rep.

+ 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] Too many arguments using nested ifs
    By eirik.joansen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-01-2021, 08:41 AM
  2. Nested IFISERROR Arguments
    By Darko_Giac in forum Excel General
    Replies: 3
    Last Post: 10-22-2020, 06:53 PM
  3. [SOLVED] Nested IF AND Statements - too many arguments
    By alexad1498 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-30-2019, 06:42 PM
  4. Too many Nested arguments > 7
    By NickTY in forum Office 365
    Replies: 5
    Last Post: 11-15-2018, 10:22 AM
  5. [SOLVED] Help with Nested IF arguments, please
    By KWiseman in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-13-2018, 04:23 AM
  6. 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
  7. Going beyond 7 Nested If Arguments
    By Supdem in forum Excel General
    Replies: 2
    Last Post: 08-05-2009, 03:06 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