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

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

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
50,527
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,118,075
Messages
5,570,051
Members
412,309
Latest member
essobsan
Top