<div>
=IFERROR(IF(AND(2000&lt;=$A2,<wbr />$A2&gt;=1000)<wbr />,$E2/$A2,&quot;<wbr />&quot;),&quot;&quot;)<br />
<br />
Kevin
</div>


=IFERROR(IF(AND(2000<=$A2,$A2>=1000),$E2/$A2,""),"")

Kevin

<div>
Or...<br />
<br />
=IF(AND($A2&gt;=1000,$A2&lt;=200<wbr />0),$E2/$A2<wbr />,&quot;&quot;)<br />
<br />
because you don't need to worry about #DIV/0 if A2 is always between 1000 and 2000.<br />
<br />
Kevin
</div>


Or...

=IF(AND($A2>=1000,$A2<=2000),$E2/$A2,"")

because you don't need to worry about #DIV/0 if A2 is always between 1000 and 2000.

Kevin

<div>
<div class="content wysiwyg-content">
I am trying to come up with an IF statement to look at column A and see if its between two numbers...<br />
<br />
=IFERROR(IF(2000&lt;=$A2&gt;=100<wbr />0,$E2/$A2,<wbr />&quot;&quot;),&quot;&quot;)<br />
<br />
What I am using doesnt seem to be working correctly. I have tried to swap the &lt;&nbsp;&gt;, but it doesnt seem to work.
</div>
</div>


I am trying to come up with an IF statement to look at column A and see if its between two numbers...

=IFERROR(IF(2000<=$A2>=1000,$E2/$A2,""),"")

What I am using doesnt seem to be working correctly. I have tried to swap the < >, but it doesnt seem to work.

I need to update the following formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.