still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 821
- Office Version
- 365
- Platform
- Windows
Hi
I have the following IF/Then statement
I want "1" returned if any part of the text in a1 starts with ab, even it it's more than one word
I tried ab*, but I don't know what else to try
Mike
I have the following IF/Then statement
HTML:
=If(a1="ab",1,2)
I want "1" returned if any part of the text in a1 starts with ab, even it it's more than one word
I tried ab*, but I don't know what else to try
Mike