title: Assign a tier to each price in a spreadsheet
body: <p>Let's say I have a price list with several hundred entries.
  I would like to create price-based categories, such as "Under $ 100", "$ 101 to $ 500", "$ 501 to $ 1000", and "Over $ 1000".</p>
  
  <pre><code>Price   Formula   Tier
  $  74    ????     Under $ 100  
  $ 199    ????     $ 101 to $ 500
  $ 745    ????     $ 501 to $ 1000
  </code></pre>
  
  <p>I know there's a way to do this in Google Sheets, but can't really figure out how.
  Is there a more elegant solution than nested IF statements?</p>