IF and Or function

[Rompetelo]

Hi everyone,

Does anybody know why my if and or don't work> I keep on getting the VALUE error

=IF(OR(A3= "CCU", "CCY"), "Y", "N")


Thanks,

[Andy Pope]

Your second or argument was not TRUE or FALSE but simply text.

=IF(OR(A3= "CCU", A3="CCY"), "Y", "N")

[Rompetelo]

Thanks Andy