IF formula bot working correctly when looking at penny values

cmerrick

Board Regular
Joined
Jun 8, 2017
Messages
75
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' ?
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

gaz_chops

Well-known Member
Joined
Apr 29, 2003
Messages
6,468
Platform
  1. MacOS
Use round

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,511
Office Version
  1. 365
Platform
  1. Windows
How about
=IF(round(K9,2)<round(D7,2),"Unacceptable","Acceptable")
 

Watch MrExcel Video

Forum statistics

Threads
1,114,613
Messages
5,549,006
Members
410,888
Latest member
leap out
Top