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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

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
51,086
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,119,182
Messages
5,576,569
Members
412,733
Latest member
korayuyanik
Top