CONDITIONAL FORMATTING

[Donna]

I have a row that adds across, a column that a total figure is multiplied by
the tax rate, I want this figure to return a number if it does not balance to
return false. I have this working now

=IF(SUM(E17*8.75%)=SUM(B1919), SUM(B1919),"FALSE")

the only problem is that when the tax rate makes the figure $73.752 and the
figure across is 73.76 I want them to still be equel. Help please.

 

[Bernard Liengme]

Let's begin with a minor item = the first SUM is not needed
=IF(E17*8.75%=SUM(B1919), SUM(B1919),"FALSE")

It is very likely that you are getting the well know "penny error". See
http://www.mcgimpsey.com/excel/pennyoff.html

If you are prepared to overlook a 1 cent difference then:
=IF( ABS(E17*8.75%-SUM(B1919)) <=0.01, SUM(B1919),"FALSE")

best wishes