Recently I came across a situation in which I needed to create an IF statement for the months in a fiscal calendar. This IF statement required 12 arguments, i.e. one IF statement for each month. However, the error below kept on showing up as I created an If statement with 12 argument
To avoid this error I found a simple solution. I divided the IF statement arguments into two parts (i.e. within two cells) each containing less than 7 arguments and then I referenced the second IF statement within the last argument of the first IF statement.