i got it to work, the if tru/ not true where mixed up

=(IF(D4="30000104";0;IF(ISERROR(FIND("TRAVEL";F4)) ;IF(ISERROR(FIND("NON
APPROVED";F4));H4/520;0);0)))

"jan" wrote:

your right.

=(IF(D2="30000104";0;IF(ISERROR(FIND("TRAVEL";F2;1 ));0;IF(ISERROR(FIND("NON
APPROVED";F2;1));0;H2/520))))

F2 contains the text, if it either contains "travel" or "non approved" the
output should be 0 if not the result must be H2/520

hope this helps

"Mike H" wrote:

Jan,

You aren't being really clear about what you want. The finds the position of
the first letter of the string in the sentence in a1

=SEARCH("non approved",A1)

Having found that what do you want to do?

Mike

"jan" wrote:

Ron,

yes I tried to apply the standard functions but cannot solve it myself.

i need to find the string "non approved" in a sentence.

regards.

"Ron Rosenfeld" wrote:

On Sat, 13 Sep 2008 11:38:01 -0700, jan wrote:

i'm struggling to find a word in a specif text string, any ideas?

thanks

Did you try the FIND or SEARCH worksheet functions?
--ron