title: multiple conditionals in excel is there a better function to use
body: <p>I'm having a problem with my excel formula, the formula is supposed to basically be a bunch of if functions written out it looks like</p>
  
  <pre><code>If (h3&lt; 1, H3+1),
  If (h3&gt;= 5 and H3&lt;= 10, H3+2),
  Else H3+3
  </code></pre>
  
  <p>I tried to put it into an excel formula based on what I saw online and some YouTube videos on if functions in excel but it's saying I added too many arguments. "Error: You've entered too many arguments for this function". Is there a better way to do this formula? Should I be using AND instead of multiple IF's? Does anyone have any advice or suggestions? Also any recommendations on how to improve with excel?</p>
  
  <p>Here's my current formula:
  '''</p>
  
  <pre><code>=IF(H3&gt;10, H3+3,
  IF(H3&lt;=10, H3&gt;=5, H3+2,
  IF(H3&lt;1, H3+1)))
  </code></pre>
  
  <p>'''</p>
  
  <p>I expect for the formula to add either 1, 2, or 3 based on H3.</p>