Can this be simplified
 

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

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

The formula works OK for me WITHOUT being array-entered (since we are
dealing with array constants and not array variables).

"JE McGimpsey" wrote in message
...
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

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

Yup - I'd originally written the response with several different
solutions, and neglected to take the array-entry out when I edited.

Thanks for the correction!

In article ,
"Shatin" wrote:

The formula works OK for me WITHOUT being array-entered (since we are
dealing with array constants and not array variables).