View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Donna Donna is offline
external usenet poster
 
Posts: 180
Default CONDITIONAL FORMATTING

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.