View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sarah (OGI) Sarah (OGI) is offline
external usenet poster
 
Posts: 128
Default Calculation based on certain criteria

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?