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?