I"m a little stuck. I've built a ton of formulas in the past but I can't seem to get this one to work the way I want. I've been working with the below categories and trying to create a specific if formula that returns the needed value. In this case if the value in the casual column is Y and the value in the non casual column is N then i need the formula to return Y but if the value in the casual column is Y and the value in the non casual column is Y then i need the formula to return N. Any help is appreciated! I've added some sample data below.
[TABLE="width: 182"]
Casual
[/td][td]Noncasual
[/td][td]Is user only casual?
[/td][/tr][tr][td]Y
[/td][td]Y
[/td][td]N
[/td][/tr][tr][td]N
[/td][td]Y
[/td][td]N
[/td][/tr][tr][td]Y
[/td][td]N
[/td][td]Y
[/td][/tr][tr][td]N
[/td][td]N
[/td][td]Y
[/td][/tr]
[/TABLE]