Calculation based on certain criteria
This worked a treat, many thanks!!
"Mike H" wrote:
=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?
|