title: How to limit a max value in a cell?
body: <p>I am setting up a new spreadsheet in google spreadsheets and I need to set a max value because it can surpass that number.  </p>
  
  <p>I am currently using this formula -> <code>=SUMPRODUCT(D17:D33)</code> and that sum can be more than 50, and if that's true, I want to limit to 50. </p>
  
  <p>Any tips?</p>