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.

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

Leave a Reply

Your email address will not be published.