| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| locking formulas?? | Excel Discussion (Misc queries) | |||
| Wildcards in formulas? | Excel Worksheet Functions | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Linear Mode
