try

=IF( abs($AI91=$C175)<=10,"Yes","No")

<div>
Again, worked great. &nbsp;Thanks ++++++
</div>


<div>
<div class="content wysiwyg-content">
I have a cell with the following formula:<br />
<br />
=IF($AI91=$C175,&quot;Yes&quot;,&quot;No&quot;<wbr />)<br />
<br />
Unfortunately if the values are not exactly the same, alarms go off. &nbsp;The values only need to be with $10.00 of each other. <br />
<br />
How would I change the formula to accomplish this?
</div>
</div>


I have a cell with the following formula:

=IF($AI91=$C175,"Yes","No")

Unfortunately if the values are not exactly the same, alarms go off.  The values only need to be with $10.00 of each other. 

How would I change the formula to accomplish this?

Testing for values that are close, but do not have to be exact.

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