If's conditions about matching
Try these:
For text in A1
1)If the first letter of the statement is "A" or number "2"
B1: =IF(OR(LEFT(A1,1)={"A","2"}),"YES","NO")
2)If the second word of the statement is "join" or "joins" or "joined"
Maybe this:
B1: =IF(ISNUMBER(SEARCH("join",A1,SEARCH(" ",A1))),"YES","NO")
Note: this one will also match on "joint". Is that ok?
3)If there's a phrase (eg paid by cash) in the statement
B1: =IF(ISNUMBER(SEARCH("paid in cash",A1)),"YES","NO")
4)Whether the phrase appears at the start, in the middle, or at the end of the
statement
B1:
=INDEX({"NO","START","MIDDLE","END"},COUNTIF($A1,$ C$1&"*")*2+COUNTIF($A1,"*
"&$C$1&" *")*3+COUNTIF($A1,"* "&$C$1)*4)
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"0-0 Wai Wai ^-^" wrote:
How can I code these if's conditions:
1)
If the first letter of the statement is "A" or number "2"
2)
If the second word of the statement is "join" or "joins" or "joined"
3)
If there's a phrase (eg paid by cash) in the statement
4)
Whether the phrase appears at the start, in the middle, or at the end of the
statement
The position of the phrase:
Statement 1: {phrase}... ... [start]
Statement 2: ...{phrase}... [middle]
Statement 3: ... ...{phrase} [end]
Thank you!
--
Additional info about my computer:
- Office XP
- Windows XP Pro
|