Error "Wrong number of arguments to IF. Expected between 2 and 3 arguments, but got 1 arguments-CodePudding

I'm trying to create a logic as the title but "Wrong number of arguments to IF. Expected between 2 and 3 arguments, but got 1 arguments" what am i doing wrong?

formula:

=IF(OR(U28=1,isnumber(MATCH("TERMINATE",P28,0)),"COMPLETE","PENDING"))

CodePudding user response：

Mismatch of brackets () , try below formula:

=IF(OR(U28=1,isnumber(MATCH("TERMINATE",P28,0))),"COMPLETE","PENDING")

CodePudding user response：

try:

=IF((U28=1) (ISNUMBER(MATCH("TERMINATE", P28, ))), "COMPLETE", "PENDING")