title: What formula or method could I go to subtract amounts from values in a range using a table
body: <p>I have a master sheet with values of what I would sell for. I want to create a formula or rules where I can subtract commission based on the value of the cell. I want to be able to edit from the table only so I don't have to mess around with hundreds of cells formulas when things change. I also don't want to just take commission by percentage. I know how to link the cells. I want a formula that will look in the table and say hey its between the two values so ill extract this amount of commission. I have attached a picture of an example of the rules table. </p>
  
  <p>I've tried doing <code>IF</code> statements and ran into too many arguments issues.</p>
  
  <p>I expect the formula to look in my table and take out the proper commission beside it.</p>
  
  <p><img src="https://i.stack.imgur.com/kZoLs.png" alt="Sample Table"></p>