+ Reply to Thread
Results 1 to 8 of 8

Nested IF - too many arguments

  1. 04-08-2022, 05:46 PM #1
    northernwarrior
    northernwarrior is offline
    Forum Contributor
    Join Date
    04-02-2019
    Location
    Ottawa,Ontario
    MS-Off Ver
    365
    Posts
    180

    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
    Reply With QuoteRegister To Reply
  2. 04-08-2022, 06:02 PM #2
    TMS
    TMS is offline
    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
    44,425

    Re: Nested IF - too many arguments

    Untested, but try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 04-08-2022, 06:08 PM #3
    TMS
    TMS is offline
    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
    44,425

    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.
    Reply With QuoteRegister To Reply
  4. 04-08-2022, 06:27 PM #4
    northernwarrior
    northernwarrior is offline
    Forum Contributor
    Join Date
    04-02-2019
    Location
    Ottawa,Ontario
    MS-Off Ver
    365
    Posts
    180

    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.
    Reply With QuoteRegister To Reply
  5. 04-08-2022, 06:48 PM #5
    TMS
    TMS is offline
    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
    44,425

    Re: Nested IF - too many arguments

    Something like:
    =K3+TIME(0,1,0)
    =K3+TIMEVALUE("00:01:00")
    Reply With QuoteRegister To Reply
  6. 04-08-2022, 06:50 PM #6
    TMS
    TMS is offline
    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
    44,425

    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).
    Reply With QuoteRegister To Reply
  7. 04-08-2022, 06:55 PM #7
    northernwarrior
    northernwarrior is offline
    Forum Contributor
    Join Date
    04-02-2019
    Location
    Ottawa,Ontario
    MS-Off Ver
    365
    Posts
    180

    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 !!!!!
    Reply With QuoteRegister To Reply
  8. 04-08-2022, 08:37 PM #8
    TMS
    TMS is offline
    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
    44,425

    Re: Nested IF - too many arguments

    You're welcome. Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1