I have a basic budget spreadsheet set up. The IF formula I have set up (which
works accurately for other parts of the spreadsheet) involves three columns:
Cost Budgeted, Actual Cost and Difference. The Difference column is like it
says, the difference between the Cost Budgeted and the Actual Cost. I also
have to simple SUM functions at the base of the Cost Budgeted and Actual Cost
columns.

The IF function I have set up is as follows:

=IF((C10-F10)=SUM(H3:H8),SUM(C10-F10),"Error")

C10 is the Cost Budgeted total, F10 is the Actual Cost total, and the
SUM(H3:H8) is the sum of all the differences (each of those are simple
formulas. I'm basically verifying that the numbers match up like they should.
However in this instance they are not - thus giving me the "Error" as the
False.

When calculated separately, C10-F10= -5.58 and SUM(H3:H8)= -5.58 as well yet
the function keeps telling me it's false. Is this because there are negative
numbers? Or is there something wrong? As I stated before, I use this same
exact funtion in other parts of the spreadsheet and they all work accurately
except in this case. Thanks and I can provide a copy of the spreadsheet if
needed.