CONDITIONAL FORMATTING

D

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(B19:D19), SUM(B19:D19),"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.
 
B

Bernard Liengme

Let's begin with a minor item = the first SUM is not needed
=IF(E17*8.75%=SUM(B19:D19), SUM(B19:D19),"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(B19:D19)) <=0.01, SUM(B19:D19),"FALSE")

best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top