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