IF formula bot working correctly when looking at penny values

[cmerrick]

So I have the following formula

=IF(K9<D7,"Unacceptable","Acceptable")

Both values are the same (£592,543.21) but the formula still displays the result 'Unacceptable'.

I think this might be down to the 'accounting formatting'. The general values are - D7 = 592543.21 & K9 = 592543.2099. Using these values, the formula is correctly displaying the 'unacceptable' result.

How can I display as ' Accounting formatting - £' but have it so that the figures as seen as equal and thus display as 'acceptable' ?

 

[gaz_chops]

Use round

=IF(ROUND(K9,2)<ROUND(D7,2),"Unacceptable","Acceptable")

 

[Fluff]

How about
=IF(round(K9,2)<round(D7,2),"Unacceptable","Acceptable")