Or =IF(ISERROR(SEARCH("travel",M2)),105,117.5)*S2/100
--
David Biddulph

"Mike H" wrote in message
...
=IF(ISERROR(SEARCH("travel",M2)),S2/105*100,S2/117.5*100)

"Sarah (OGI)" wrote:

Thanks Mike, but M2 won't specifically just say "Travel", it will contain
the
word "travel" if it says it at all, which is what I'm stuggling with.

"Mike H" wrote:

Try

=IF(M2="Travel",S2/117.5*100,S2/105*100)

Mike

"Sarah (OGI)" wrote:

If M2 contains the word "travel", then I want to perform the
following
calculation on S2:
=S2/117.5*100

If M2 does not contain the word "travel", then I want to perform the
following on S2:
=S2/105*100.

What is the best way of writing this in a formula?