Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |