title: if formula multiple conditions
body: <p>I know there is a lot of threads out there about this and I have gone through my share of them looking for an answer.</p>
  
  <pre><code>D7 and F7 is formatted to currency Rand
  E7 will be text or blank
  </code></pre>
  
  <p>I have 3 conditions in the formula that needs to be met before it provides one of two answers:</p>
  
  <pre><code>cell of formula is F7
  if D7 is =&gt;50
  if D7 is =&lt;-50
  if E7 is =0
  </code></pre>
  
  <p>Basically anything higher than <code>49.99</code> regardless if it is a minus or not and as long as E7 is a blank cell.</p>
  
  <p>Then it should produce the answer <code>59</code>. If all of these conditions are not met it should give <code>0</code>.</p>
  
  <p>tried the below formula but does not give me any results, just stays on zero.</p>
  
  <pre><code>=IF(AND(D7&lt;=-50,D7&gt;=50,E7=0),(59),(0))
  </code></pre>