title: IFS multiple cells with 'greater than' 'less than' condition in one cell
body: <p>Good morning,</p>
  <p>If there is no value in B3 then the following calculation is needed, otherwise, the value in B3 should be used.</p>
  <pre><code>=IFS(B1&gt;1000,(B1-1000)*0.06+200,B1&lt;1001,B1*0.06)
  </code></pre>
  <p>But I can't seem to add <strong>B3=&quot;&quot;</strong> to the beginning of the code without breaking it - please can someone let me know what I'm doing wrong?</p>
  <p>Many thanks,</p>