conditional format and rounding error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am using a conditional format to flag if a two cells do not match. I am getting a return when the viewable numbers are identical. Its true, they are different at 9 decimal points out.

275,682.32000000000
275,682.319999999

How do I set this so I don't get a return if the numbers are the same at only two decimal points ? Right now the equation is "cell value is not equal to = J193".

Thanks.


Todd
 
you could try rounding them, say

=ROUND(A1,3)=ROUND(B1,3)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Todd said:
Hi, I am using a conditional format to flag if a two cells do not match.
Click to expand...
I am getting a return when the viewable numbers are identical. Its true,
they are different at 9 decimal points out.
275,682.32000000000
275,682.319999999

How do I set this so I don't get a return if the numbers are the same at
Click to expand...
only two decimal points ? Right now the equation is "cell value is not
equal to = J193".
 
In the conditional formatting dialog box set condition 1:

Formula Is: (instead of cell value is, drop down list)
if your numbers are in a1 and b1 type

=round(a1,2)=round(b1,2)
That should do it...

Cheers
Juan


-----Original Message-----
Hi, I am using a conditional format to flag if a two
Click to expand...
cells do not match. I am getting a return when the
viewable numbers are identical. Its true, they are
different at 9 decimal points out.
275,682.32000000000
275,682.319999999

How do I set this so I don't get a return if the numbers
Click to expand...
are the same at only two decimal points ? Right now the
equation is "cell value is not equal to = J193".
 
Sorry... if you want the format to appear when they are
different then just use:

=round(a1,2)<>round(b1,2)

Juan
 
Back
Top