If else question

[hudsonhacker]

Okay, full on newbie. I am having trouble writing an if else formula.
I am checking 4 cells for a name (Cells are I6, I7, I9, I10). If the name (A36) is not in any of the cells, I would like the formula to put a value of 0 in the cell. I have figured out the "IF" portion, but cannot figure out how to return a 0 if all of the arguments are false. I am sure it is darn easy, I just do not know how to do it. Please bear with me, I am learning.

My current formula is:
=IF(I6=A36,K6,IF(I7=A36,K6,IF(I9=A36,K9,IF(I10=A36,K9))))

 

[JackDanIce]

Try:

=IF(ISERROR(MATCH,A36,I6:I10,0),0,K6)

 

[JackDanIce]

Otherwise, try:

=IF(OR(I6=A36,I7=A36,I8=A36,I9=A36,I10=A36),K6,0)