Either/Or Auto Fill

[erin-5304]

I haven't used a formula for this before.

I need to fill E41 with data that could come from 2 different cells.

If C54 is Y then E41 fills Y, if C55 is Y then E41 is Y.

If they are both N, E41 auto fills N.

How would this formula go?  This is what I had but I don't think I'm close...

[#2]

@erin-5304 

=IF(AND(C54="N",C55="N"),"N",IF(C54="Y","Y",IF(C55="Y","Y","")))

Is this what you are looking for? 

[#3]

Kind of; it needs to be an either/or not both. So, if C54 is Y and C55 is N, E41 is still Y. If either of them are Y then E41 needs to be Y, if neither are Y then E41 needs to be N. Sorry, I might not be explaining it very well.

[#4]

@erin-5304 

Naming the range C54:C55 to be 'assessment', the result becomes

= IF(OR(assessment="Y"),"Y","N")

In the event that you require two "Y"s to revert to "N" then 'exclusive or' is an alternative form

= IF(XOR(assessment="Y"),"Y","N")