If or if not text is present

[dparteka]

This doesn't look that difficult to me, but I just haven't been able to make anything work, any help will be greatly appreciated.

Looking for a formula to be placed in J2
F2 may or may not have one of two texts "Finish" or " Angle"
If F2 has either one of these texts then J2 should equal G2
If F2 does not have either text then J2 would G2*25.4

 

[Somendra Misra]

Hi,

Can you try this:

=IF(OR(F2="Finish",F2="Angel"),G2,G2*25.4)

and your Angel has a extra space.

Regards,

 

[dparteka]

SM... works great except for one thing that I neglected to mention, the text "Finish" and "Angle" are just two words of a larger string of text, so the formula needs to search through the entire string to find them.

 

[Somendra Misra]

Can you post a sample so that we achieve at a formula, or try this one:

=IF(OR(ISNUMBER(SEARCH("Finish",F2)),ISNUMBER(SEARCH("Angel",F2))),G2,G2*25.4)

Regards,

 

[dparteka]

SM... after further review I think I'll use it as is, thanks for the help, it's greatly appreciated

 

[Somendra Misra]

You are Welcome.

Regards,