Check my IF function

K

KH_GS

I'm suppose to catch words that end with "ing".

In this case it only catches words that end with "ing(space)", and no
the word at the end.

= IF(OR((ISERROR( FIND("ing ",A3))), (ISERROR(RIGHT(A3, 3)= "ing")))
"",A3)

Data:
playing ball
running shoe
battling
resist running
box
carton milk

Output:
playing ball
running shoe


My ideal output is:
playing ball
running shoe
battling
resist runnin
 
B

Bob Phillips

=IF(ISNUMBER( FIND("ing ",A3)),TRIM(A3),IF(RIGHT(A3, 3)="ing",A3,""))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
P

Pete_UK

Try this variation:

= IF(ISERROR(FIND("ing ",A3)),"",IF(ISERROR(RIGHT(A3, 3)=
"ing"),"",A3))

Hope this helps.

Pete
 
B

Bob Phillips

Have you tried my suggestion?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
G

Gerry-W

This works for me:

=IF(RIGHT(TRIM(A8),3)="ing",A8,IF(ISERROR(FIND("ing ",A8)),"",A8)
 
B

Bob Phillips

Great.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top