title: How to write nested if function in Excel for the below condition
body: <p>I am having an excel sheet with columns A to H and need to write a formula satisfying the below condition which has multiple nested If conditions:</p>
  <p>if D &lt; C and C &lt;= B</p>
  <pre><code>    if J &lt;= D, Value - D
      if J &gt; D and J &lt;= C and G &lt;= 2%, Value - C
      else Value - None
  </code></pre>