IF statements

Occasional Visitor

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.


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



2 Replies


If should be




But I'd prefer




or even shorter



@Hans Vogelaar 

Or even