formula to check Cell value within specific character
 

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

formula to check Cell value within specific character
 

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

On Feb 12, 5:38 pm, TA wrote:
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

formula to check Cell value within specific character
 

=IF(OR(A1={"A","D","G","Z"}),"within a range","no")


"TA" wrote:

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