Wildcards in Formulas

G

GOL

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.
 
K

KL

Hi,

Try this:

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

or

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


Regards,
KL
 
D

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.
Click to expand...
 
Top