Issue with OR or Wildcard?

[slam]

I'm trying to make a formula where if a cell begins with X, Y, or Z, it shows Deprioritized, otherwise it shows Prioritized. However, my current formula is showing Prioritized for all results. Am I using the OR wrong, or is my wildcard wrong?

=IF(OR(C2="X*",C2="Y*",C2="Z*"),"Deprioritized","Prioritized")

Thanks!

 

[Phuoc]

Try this:

=IF(OR(COUNTIF(C2,{"X*","Y*","Z*"})),"Deprioritized","Prioritized")

 

[Phuoc]

Or try:

=IF(OR(LEFT(C2,1)={"X","Y","Z"}),"Deprioritized","Prioritized")

 

[HighAndWilder]

I'm trying to make a formula where if a cell begins with X, Y, or Z, it shows Deprioritized, otherwise it shows Prioritized. However, my current formula is showing Prioritized for all results. Am I using the OR wrong, or is my wildcard wrong?

=IF(OR(C2="X*",C2="Y*",C2="Z*"),"Deprioritized","Prioritized")

Thanks!

Or this:

=IF(OR(COUNTIF($C2,"X*")=1, COUNTIF($C2,"Y*")=1, COUNTIF($C2,"Z*")=1), "Deprioritized","Prioritized")

Wildcards aren't recognised with comparison operators like =, for example if you use this formula
=A1="*&*"
that will treat the asterisks as literal asterisks (not wildcards) so that will only return TRUE if A1 literally contains *&*

 

[slam]

Thank you so much for your replies. Used the first solution from Phuoc