Trying to insert another if statement in an "IF(ISNUMBER(MATCH" statement.

[Greg Simon]

So I have the following formula working fine, BUT what I am trying to do is change the return values, where return value "1" is a second "IF" statement.

=IF(ISNUMBER(MATCH(Schedule!B2,Schedule!A1:A2340,0)),1,0) (this works fine) but I want the value one to check C40 and if it is "win" then return the value of C449, if it is not a win to return an X:

 =IF(C40="win",C449,X)

If I make this command on a separate cell, it works fine, but I cannot figure out how to properly insert the second IF statement into the first.

=IF(ISNUMBER(MATCH(A39,A2:A131,0)),=IF(C40="win",C449,"X"),0) is what I have written, but it is an error.

What is the correct way to write this?

[#2 · Accepted solution]

Greg,

remove the equal sign before the second IF.

=IF(ISNUMBER(MATCH(A39,A2:A131,0)),IF(C40="win",C449,"X"),0)