if statement – excel IF formula Error, Youve entered too many arguments

if statement – excel IF formula Error, Youve 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.