One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=IF(OR(B41={"AA","BB","CC"}),P42,NA())

In article ,
"Barb Reinhardt" wrote:

I have the following formula:

=(IF((OR($B$41="AA",$B$41="BB",$B$41="CC")),P42,NA ()))

I think I've seen another "more elegant" way to express it, but I just don't
remember what it is. Can someone assist?

Thanks,
Barb Reinhardt