Results 1 to 11 of 11

Too many arguments

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Borneo
    MS-Off Ver
    2016
    Posts
    277

    Too many arguments

    Dear All Experts

    I have a formula, I would like combine it, but this message appear "you've entered too many arguments fort this function"
    Could you help me, here are the formula that should be combined

    IF(AND(COUNTIF(R8:R1007,"koso*")>0,COUNTIF(R8:R1007,"kura*")<1,COUNTIF(R8:R1007,"*VGM*")<1),COUNTIF(R8:R1007,"KOSO*")&" BOOKING KOSONG"
    IF(AND(COUNTIF(R8:R1007,"koso*")<1,COUNTIF(R8:R1007,"kura*")>0,COUNTIF(R8:R1007,"*VGM*")<1),COUNTIF(R8:R1007,"Kura*")&" BOOKING MASIH KURANG"
    IF(AND(COUNTIF(R8:R1007,"koso*")<1,COUNTIF(R8:R1007,"kura*")<1,COUNTIF(R8:R1007,"*VGM*")>0),COUNTIF(R8:R1007,"*VGM*")&" BOOKING VGM PROBLEM"
    IF(AND(COUNTIF(R8:R1007,"koso*")>0,COUNTIF(R8:R1007,"kura*")>0,COUNTIF(R8:R1007,"*VGM*")<1),COUNTIF(R8:R1007,"KOSO*")&" BOOKING KOSONG"&" dan "&COUNTIF(R8:R1007,"KURA*")
    IF(AND(COUNTIF(R8:R1007,"koso*")<1,COUNTIF(R8:R1007,"kura*")>0,COUNTIF(R8:R1007,"*VGM*")>0),COUNTIF(R8:R1007,"KURA*")&" BOOKING MASIH KURANG"&" dan "&COUNTIF(R8:R1007,"*VGM*")&" BOOKING VGM PROBLEM")
    IF(AND(COUNTIF(R8:R1007,"koso*")>0,COUNTIF(R8:R1007,"kura*")<1,COUNTIF(R8:R1007,"*VGM*")>0),COUNTIF(R8:R1007,"KOSO*")&" BOOKING KOSONG"&" dan "&COUNTIF(R8:R1007,"*VGM*")&" BOOKING VGM PROBLEM")
    IF(AND(COUNTIF(R8:R1007,"koso*")<1,COUNTIF(R8:R1007,"kura*")<1,COUNTIF(R8:R1007,"*VGM*")<1),""
    IF(AND(COUNTIF(R8:R1007,"koso*")>1,COUNTIF(R8:R1007,"kura*")>1,COUNTIF(R8:R1007,"*VGM*")>1),COUNTIF(R8:R1007,"KOSO*")&" BOOKING KOSONG"&" dan "&COUNTIF(R8:R1007,"KURA*")&" BOOKING MASIH KURANG"&" dan "&COUNTIF(R8:R1007,"*VGM*")&" BOOKING VGM PROBLEM"
    Last edited by azbi; 09-23-2016 at 02:21 AM.

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
    By Allisongw in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-19-2015, 10:59 PM
  2. [SOLVED] 7+ IF arguments
    By jshephe2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-25-2014, 03:36 PM
  3. [SOLVED] Too many arguments
    By smcduffi in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-05-2012, 01:09 PM
  4. Too Many Arguments?
    By artiststevens in forum Excel General
    Replies: 2
    Last Post: 08-13-2011, 08:15 PM
  5. NEXT / FOR arguments
    By Loisw in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-19-2009, 11:37 AM
  6. Too Many Arguments
    By martinpe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-12-2008, 02:07 AM
  7. [SOLVED] Too few arguments
    By plore in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2005, 08:50 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1