<div>
Although the question is closed a simpler approach could be<br />
<br />
=max(min(i2,&quot;$6000&quot;),&quot;$200<wbr />0&quot;)
</div>


Although the question is closed a simpler approach could be

=max(min(i2,"$6000"),"$2000")

<div>
<div class="content wysiwyg-content">
Please offer why the following is not working:<br />
<br />
=IF(I2&lt;2000,&quot;$2000&quot;,IF(200<wbr />0&lt;=I2&lt;=600<wbr />0,I2,IF(I2<wbr />&gt;6000,&quot;$60<wbr />00&quot;)))<br />
<br />
Basically, if the amount is below 2000, the resulting output is 2000.<br />
<br />
If the value is &gt;= 2000 and &lt;= 6000, the value is from cell I2<br />
<br />
If the value is greater than 6000, the resulting output will be 6000.<br />
<br />
Thank you.
</div>
</div>


Please offer why the following is not working:

=IF(I2<2000,"$2000",IF(2000<=I2<=6000,I2,IF(I2>6000,"$6000")))

Basically, if the amount is below 2000, the resulting output is 2000.

If the value is >= 2000 and <= 6000, the value is from cell I2

If the value is greater than 6000, the resulting output will be 6000.

Thank you.

Excel - Nested If

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