Wildcards in Formulas

[Guest]

Im attempting to write a formula that looks like this:

If(A2="***/5",B2*3,0)

All my A column fields end in either /5 or /1, but I only want the /5
affected. Any help please.

 

[KL]

Hi,

Try this:

=IF(RIGHT(A2,2)="/5",B2*3,0)

or

=IF(COUNTIF(A2,"*/5"),B2*3,0)


Regards,
KL

 

[Dave Peterson]

One way:

=if(countif(a2,"*/5"),b2*3,0)

Im attempting to write a formula that looks like this:

If(A2="***/5",B2*3,0)

All my A column fields end in either /5 or /1, but I only want the /5
affected. Any help please.