Excel Formula Question
|
View this Thread in Original format
kadomony |
Need a formula that searches the adjacent cell for a string and returns True if it's found and False if not.
eg: i'm looking for a string "xyz"
A1||||||||B1
12xyz34w True
12xy32w False
Thanks. |
|
|
tubularbills |
=average(ta!oldest:ta!youngest) |
|
|
kadomony |
quote: | Originally posted by tubularbills
=average(ta!oldest:ta!youngest) |
thanks, but that formula returned "shenanigans" no matter what cell i referenced. |
|
|
Comrade Stalin |
Try this...
=IF(FIND("XYZ",B1),"TRUE","FALSE") |
|
|
kadomony |
quote: | Originally posted by Comrade Stalin
Try this...
=IF(FIND("XYZ",B1),"TRUE","FALSE") |
That is to be working. Thank you, komrade. |
|
|
|
|