Excel help

cdd · Tue 12 Apr, 2005 14.22

Hi, I'm appealing to any of you who know a bit about logical tests in Excel.

Basically, how can I do the logical test on whether or not a string is present in a field? I.E., a cell containing the word "example" contains the string "ample", so a logical test on that cell for the presence of the word "ample" should return true.

It might not even be possible -- if I have to go into Excel Visual Basic to do it then forget it. Any ideas?

Cheers

Chris

Sput · Tue 12 Apr, 2005 15.01

This should help:
IF(ISTEXT(A1),"Your text",Thing to output)

cdd · Tue 12 Apr, 2005 15.55

Sput wrote:This should help:
IF(ISTEXT(A1),"Your text",Thing to output)

Just the function I was after! I know the javascript equivelant (indexOf, of course) but Excel is all different like that.

Cheers