#### Foo_Man_Chu

##### Board Regular

- Joined
- Jul 22, 2010

- Messages
- 79

Code:

`=IF(AND(B1="HERE",LEFT(D3,7)="STC|A2:"),C3="HERE","")`

It didn't return the expected result of C3 = "HERE" so I evaluated it. For some reason these two parts of the formula evaluate to TRUE:

Code:

`AND(B1="HERE",LEFT(D3,7)="STC|A2:")`

but overall the formula evaluates to false. I know this isn't that hard of a formula but I'm completely stumped. Can someone help me out please? Thanks in advance.