IF statements

[jeff8ee]

Hi, this is really simple compared to all the questions here but I cant make this work. I want to create the following, but Excel keeps telling me that I have too many arguments.

Any ideas how to solve.

=IF(S28="y",J28,0,IF(S28="j",J28,0))

I just want either a Y and a J to produce the same result. Originally there was only a Y.

Thanks

Jeff

[#2]

@jeff8ee 

If should be

=IF(S28="y",J28,IF(S28="j",J28,0))

But I'd prefer

=IF(OR(S28="y",S28="j"),J28,0)

or even shorter

=IF(OR(S28={"y","j"}),J28,0)

[#3]

@Hans Vogelaar 

Or even

=XOR((S28={"y","j"}))*J28