formula to check Cell value within specific character

T

TA

any formula to check cell value within a range of character
e.g. the cell value is either one of the character e.g "A" or "D" or "G" or
"Z"
thanks
 
P

Pete_UK

How about something like this:

=IF(OR(A1="A",A1="D",A1="G",A1="Z"),action_if_true,action_if_false)

?

Hope this helps.

Pete
 
Top