IF Statement

[Sql7user]

I have a little problem, someone could help me with.

I want to use a if statement either in excel directly or in vba. With the if statement I want to mark all rows with a field containing for example "X". All the rows contains som figures or letters but only a few contains "X" and after the X there could be other figures and letters. For example:

A B C D Res
1.232525 / X 34 25 / BB / =IF(B1 "contains" X;1;0)/ 1
232585 / 23 24 / AA / / 0
798956 / X 46 48 / AA / / 1

Thanks in advance

/Sql7user

 

[SkipVought]

Hi,
[tt]
=IF(ISERROR(FIND("X",B1)),0,1)
[/tt]


Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[Sql7user]

Thanks Skip, worked perfectly!

/Sql7user