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?