IF search

[Kyli]

I need to create an "IF" statement that is similar to this
one, but that actually works!
=IF((A1)="*total",1,0)

The logic I need is "if A1 contains total, then 1, else 0".
Thank-you for your help. It is truly appreciated.

 

[Nick Hodge]

Kyli

I suspect it's not as simple as this as you have used an * for some reason,
but to do exactly as you ask...

=IF(A1="total",1,0)

Post back if you can't get it to work

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[NH]

if(isnumber(search(A1,"Total"),1,0)

 

[Frank Kabel]

Hi
try
=--(COUNTIF(A1,"*total*")>0)

 

[Ken]

Hi, try

=IF(ISERROR(SEARCH("total",A1)),"No","Yes")

 

[Jack Schitt]

Elegant

 

[Kyli]

Thanks, Frank! That's a new formula for me to play with.
: )

 

[Kyli]

Hi Nick,
I was using the asterisk because the columns are like this:
Abrams
Abrams Total
Buckhorn
Buckhorn
Buckhorn
Buckhorn
Buckhorn Total

And I only wanted to mark the ones with "Total" in their
cell. I got at least three different answers. I love
this forum!

Thanks