【How-to】How many arguments can and function have in excel

“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.