Results 1 to 13 of 13

If function - Too many arguments

Threaded View

  1. 06-23-2020, 05:54 PM #12
    6StringJazzer
    6StringJazzer is online now
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,162

    Re: If function - Too many arguments

    Here is a revised version that fixes this problem. There was no check for those two blank cells. Completely missed it.

    =IF(B2&C2&D2&E2="",IF(A2="","NO SHIFT","ON LEAVE"),IF(OR(C2="",E2="",C2>B2+TIME(0,20,0),E2<D2-TIME(0,20,0)),"NOT OK","OK"))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. IF Function - too many arguments
    By simmo86 in forum Excel General
    Replies: 2
    Last Post: 05-02-2017, 10:21 AM
  2. Too many arguments for the function
    By Patcheen in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-29-2016, 08:47 AM
  3. [SOLVED] IF function with more than 2 arguments.
    By SeanMck in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2013, 08:37 AM
  4. [SOLVED] Too Many Arguments for This Function.
    By sander07 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-22-2013, 07:34 PM
  5. two different arguments in one IF function?
    By VAZIM in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2013, 08:48 AM
  6. 10 Arguments in a function
    By noisewatter in forum Excel General
    Replies: 2
    Last Post: 04-30-2009, 01:24 PM
  7. [SOLVED] Need to open the Function Arguments window from VBA for a user defined function.
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2006, 10:55 AM

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