title: Rounding numbers in complex conditions in Excel formula
body: <p>I need to round up/down the numbers (last 2 digits, no decimal) based on three conditions:</p>
  
  <ol>
  <li>if 00, then -1</li>
  <li>if 01 to 49, then round up to 50</li>
  <li>if 51 to 98, then round up to 99</li>
  </ol>
  
  <p>examples:</p>
  
  <ul>
  <li>if the number is 1251, then it's 1299</li>
  <li>if the number is 1298, then it's 1299</li>
  <li>if the number is 4874, then it's 4899</li>
  <li>if the number is 1433, then it's 1450</li>
  <li>if the number is 1880, then it's 1899</li>
  <li>if the number is 1301, then it's 1350</li>
  <li>if the number is 1200, then it's 1299</li>
  <li>if the number is 1250, then it's 1250 (unchanged)</li>
  <li>if the number is 1299, then it's 1299 (unchanged)</li>
  </ul>
  
  <p>..................</p>