Apr 14 2022 01:36 PM
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...
Apr 14 2022 02:06 PM
=IF(AND(C54="N",C55="N"),"N",IF(C54="Y","Y",IF(C55="Y","Y","")))
Is this what you are looking for?
Apr 14 2022 02:31 PM
Apr 14 2022 03:39 PM
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")