excel IF formula Error, “You’ve entered too many arguments”

“too many arguments” means the number of “,” , “(” & “)” is not right. Just double check for each if(a,b,c) and and(a,b,c) to have enough brackets, data/arguments and comma.

In your code, there is a total of 73 pieces of “(” and only 71 “)” . Thus, it is clear that some “(” or “IF(” was not closed properly. The corrected version :

=IF(AND(S284<>"",R284<>"",A284<>B284),INDEX(RATE, MATCH($A284,BID_NO,0), MATCH($R284,RATES,0)),  IF(AND(S284<>"'',R284="",A284<>B284),INDEX(SHIFT_INFO, MATCH($A284,SHIFT_BID,0), MATCH(L$4,SHIFT_HEADER,0)),  IF(AND(S284="",R284<>"",INDEX(SHIFT_INFO, MATCH($B284,SHIFT_BID,0), MATCH(L$4,SHIFT_HEADER,0)) <> INDEX(SHIFT_INFO, MATCH($A284,SHIFT_BID,0))),INDEX(RATE, MATCH($A284,BID_NO,0), MATCH($R284,RATES,0)),  IF(AND(S284="",R284="",INDEX(SHIFT_INFO, MATCH($B284,SHIFT_BID,0), MATCH(L$4,SHIFT_HEADER,0)) <> INDEX(SHIFT_INFO, MATCH($A284,SHIFT_BID,0))),INDEX(SHIFT_INFO, MATCH($A284,SHIFT_BID,0), MATCH(L$4,SHIFT_HEADER,0)),""))))

That should be sufficient.

Hope that solves.. (:

p/s: you may use notepad++ or other coding tools to help “highlighting” the brackets pair too.

Related Posts:

  1. Is double square brackets [[ ]] preferable over single square brackets [ ] in Bash?
  2. Why does python use ‘else’ after for and while loops?
  3. Help needed with Median If in Excel
  4. Python Invalid syntax in elif
  5. if else construction
  6. Using if-else in JSP
  7. ternary operator in matlab
  8. Batch – If, ElseIf, Else
  9. if else statement in AngularJS templates
  10. Pig Latin Translator
  11. MS Excel Scatterplot converts Months to Numbers
  12. && (AND) and || (OR) in IF statements
  13. Substring in excel
  14. IndexError: too many indices for array
  15. ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
  16. How to use *ngIf else?
  17. IndexError: too many indices for array
  18. Swap x and y axis without manually swapping values
  19. Excel: Calculate the frequency of a particular month in a column of date cells
  20. Python inline if statement
  21. if else in a list comprehension
  22. How do I perform an IF…THEN in an SQL SELECT?
  23. Python’s equivalent of && (logical-and) in an if-statement
  24. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  25. Invalid column count in CSV input on line 1 Error
  26. How to find a value in an excel column by vba code Cells.Find
  27. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  28. Object Required Error in excel VBA
  29. “[ ]” vs. “[[ ]]” in Bash shell
  30. How do I compare two string variables in an ‘if’ statement in Bash?
  31. Else without if
  32. If vs. else if vs. else statements?
  33. Declaring variables in Excel Cells
  34. What are .NumberFormat Options In Excel VBA?
  35. Better way to find last used row
  36. VBA, if a string contains a certain letter
  37. break out of if and foreach
  38. How to write an inline IF statement in JavaScript?
  39. How to loop in excel without VBA or macros?
  40. Required: Variable Found: Value
  41. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  42. What exactly is the function of Application.CutCopyMode property in Excel
  43. Multiple OR or AND conditions in IF statement
  44. Excel – SUMIFS for multiple columns
  45. Workaround for “Formula omits adjacent cells”
  46. Bash if statement with multiple conditions throws an error
  47. Select method of Range class failed via VBA
  48. Is it possible to force Excel recognize UTF-8 CSV files automatically?
  49. Why does “Paste Method of Worksheet class failed” occasionally occur?
  50. PHP if not statements
  51. Excel Filters – show only relevant values in the filter
  52. Lua – if statement with two conditions on the same variable?
  53. check if a file is open in Python
  54. How to return a result from a VBA function
  55. Exception from HRESULT: 0x800A03EC Error
  56. Use VBA to Clear Immediate Window?
  57. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  58. Excel: Can I create a Conditional Formula based on the Color of a Cell?
  59. Syntax error on token(s), misplaced construct(s)
  60. JAVA Variable declaration not allowed here
  61. How to resolve “Syntax error on token “else”” in Java?
  62. Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
  63. ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine.
  64. break statement in “if else” – java
  65. How do I open space-delimited file in Microsoft Excel?
  66. if else function in pandas dataframe
  67. VBA: Convert Text to Number
  68. VBA Error: “Compile error: Expected End Sub”
  69. Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support
  70. Scraping data from website using vba
  71. Error -1072896636 “DTD Prohibited” when opening xml file in Excel, what do I do?
  72. Meaning of “[: too many arguments” error from if [] (square brackets)
  73. Does Lua have OR comparisons?
  74. How to open an Excel file in C#?
  75. VB: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)
  76. Loop without Do error
  77. Row count where data exists
  78. How to install Date Picker form control in Excel 2016
  79. How to install Date Picker form control in Excel 2016
  80. How to fill color in a cell in VBA?
  81. (Excel) Conditional Formatting based on Adjacent Cell Value
  82. If variable equals value php [duplicate]
  83. How to implement if-else statement in XSLT?
  84. Test or check if sheet exists
  85. Is there a coalesce-like function in Excel?
  86. How to detect if user select cancel InputBox VBA Excel
  87. How to resolve “Syntax error on token “else”” in Java?
  88. Shortcut to Apply a Formula to an Entire Column in Excel
  89. macro run-time error ‘9’: subscript out of range
  90. How to label scatterplot points by name?
  91. JavaScript single line ‘if’ statement – best syntax, this alternative?
  92. Using OR operator in a jQuery if statement
  93. Styling multi-line conditions in ‘if’ statements?
  94. Average in VBA in Excel
  95. PHP Like thing similar to MySQL Like, for if statement?
  96. Paste Special error 1004 PasteSpecial method of Range class failed
  97. Compare two columns using pandas
  98. VBA: Getting run-time 1004: Method ‘Range’ of object ‘_Worksheet’ failed when using cells
  99. Cannot run the macro… the macro may not be available in this workbook
  100. Is there a way to crack the password on an Excel VBA Project?

Leave a Comment

tech