View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default CONDITIONAL FORMATTING

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
--
Bernard Liengme
MVP Excel
http://people.stfx.ca/bliengme

"Donna" wrote in message
...
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.