# IF formula bot working correctly when looking at penny values

#### cmerrick

##### Board Regular
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' ?

### Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

#### gaz_chops

##### Well-known Member
Use round

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

#### Fluff

##### MrExcel MVP, Moderator
=IF(round(K9,2)<round(D7,2),"Unacceptable","Acceptable")

Replies
17
Views
815
Replies
3
Views
352
Replies
7
Views
117
Replies
8
Views
2K
Replies
2
Views
337

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,505
Messages
5,832,117
Members
430,111
Latest member
Francis Xavier

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back