Wildcards in Formulas
 

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.

Hi,

Try this:

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

or

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


Regards,
KL

"GOL" wrote in message
...
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.

One way:

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

GOL wrote:

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.

--

Dave Peterson