title: Scaled percentage calculator - specific percentages for different number outcomes
body: <p>We are a group based fitness studio working on a sheet that gives information on expenses and profits, most of the sheet is pretty straight forward, however, we want the sheet to calculate the royalty the investor should get but it is calculated on a sliding percentage calculator, i.e</p>
  <p>0 - 199 members - 10% of gross revenue
  200 - 299 Members - 12% of gross revenue
  300 - 399 Members - 14% of gross revenue
  400 - 499 Members - 16% of gross revenue
  500+ members - 18% of gross revenue</p>
  <p>The desired outcome is to produce a sheet that automatically switches the calculation from one percentage to another once the member number goes to the next member bracket (as stated above).</p>
  <p>Obviously we could have a sheet that has multiple calculations to work this out but ideally, we want it worked out in the one cell to make it easier for an individual to understand.</p>
  <p>I have added a link to the sheet below so you can see what we are looking to achieve</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1E9_42vNvZgf_TmzJgX3MlNZO57SjriU7GZT6HTF6rAo/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1E9_42vNvZgf_TmzJgX3MlNZO57SjriU7GZT6HTF6rAo/edit?usp=sharing</a></p>