title: Limiting cell values in formulas
body: <p>I would like to use some kind of limit or over/under rule in a formula. The premise is if a number exceeds a certain value, then I only want to take that certain value. Here's an example:</p>
  
  <p>If an employee's hours exceed 80 hours per month, only use 80 hours for accounting purposes. Let's say my employee Bob's timesheet looks like this:</p>
  
  <p>Jan = 20 hours</p>
  
  <p>Feb = 40 hours</p>
  
  <p>Mar = 100 hours</p>
  
  <p>Apr = 60 hours</p>
  
  <p>etc.</p>
  
  <p>If Bob gets paid $100/hours, then his final payment should be $100/hour * total hours works. Or in excel format, something like =100*sum(b1:b12) if hours are stored in column B.</p>
  
  <p>BUT, I only want to take a Maximum of 80 hours each month... So the hours in the above example, as far as accounting is concerned, would look like this:</p>
  
  <p>Jan = 20 hours</p>
  
  <p>Feb = 40 hours</p>
  
  <p>Mar = <strong>80 hours</strong></p>
  
  <p>Apr = 60 hours</p>
  
  <p>etc.</p>
  
  <p>I'd rather not build in another column for =if(b1>80,80,b1). And to be honest, it's bugging me now that I can't figure it out.</p>
  
  <p>Please help!</p>