| Author |
Message
|
| dflowe |
 Posted: Sun Apr 08, 2012 2:34 pm Post subject: exel code |
 |
|
Joined: 31 Dec 2005
Posts: 82
Location: Midlands
|
Hi, I am trying to get a 1 if a race title string at A1 contains the text Chs
I have tried find but it gets a 1 if it contains Chs but error if not and I need a 0, any ideas?
thanks
Dave |
|
| Back to top |
|
 |
| osknows |
| Posted: Sun Apr 08, 2012 2:39 pm Post subject: |
|
|
Joined: 28 Jul 2009
Posts: 792
|
Hi Dave,
This Excel formula should do what you need
=IF(ISERROR(FIND("Chs",A1,1)),0,1) |
|
| Back to top |
|
|
| dflowe |
| Posted: Sun Apr 08, 2012 2:48 pm Post subject: |
|
|
Joined: 31 Dec 2005
Posts: 82
Location: Midlands
|
Oh bugger, I tried ERROR but not ISERROR, thanks for that will bang it in
thanks
Dave |
|
| Back to top |
|
|
|
|
