Forum Discussion
Greg Simon
Sep 20, 2017Copper Contributor
Trying to insert another if statement in an "IF(ISNUMBER(MATCH" statement.
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?
Greg,
remove the equal sign before the second IF.
=IF(ISNUMBER(MATCH(A39,A2:A131,0)),IF(C40="win",C449,"X"),0)
- Detlef_LewinSilver Contributor
Greg,
remove the equal sign before the second IF.
=IF(ISNUMBER(MATCH(A39,A2:A131,0)),IF(C40="win",C449,"X"),0)