True/False statement returns False when True

[TMLstan]

I am using a true/false statement to double check sum of columns and row allocations on a budget. For some reason, the last true/false statement keeps returning a FALSE when the result is TRUE.

You can't see the column/row numbers in the image I am attaching but the formula for the cell returning the FALSE result is an if/then formula subtracting the value in the cell to the left (checksum column) from the value in the Per Period column total. So, in other words, If 36,692.62 - 36,692.62 = 0, true, false. Both cell references are TRIM'd. Both are formatted the same (accounting, 2 decimal).

Why would this be returning a FALSE statement. All of the tests above are similar tests.

Thanks for any guidance.

 

[Michael M]

Without seeing the data in it's true form, I'd say it's a rounding error
If each column total is derived by formula the answer may APPEAR to be correct but has a few "cents" carry over, especially if there is any multiplication or Division involved

 

[TMLstan]

Without seeing the data in it's true form, I'd say it's a rounding error
If each column total is derived by formula the answer may APPEAR to be correct but has a few "cents" carry over, especially if there is any multiplication or Division involved

Thanks for quick response. I was presuming the same, thus the use of the TRIM function which I thought accounted for the rounding errors.

I don't think I can post the original data can I? My understanding was that it had to be an image. You are correct that the other totals are all derived from by formula.

 

[Michael M]

No, TRIM doesn't account for rounding.
If you use the XL2BB to post your data, we can have a play with it.......note the XL2BB icon at the end of the reply toolbar

 

[TMLstan]

Sorry, having trouble browsing to the downloaded add-in. Still working on it.

 

[Michael M]

Also,have a look at the MROUND function for dollar values !!

 

[TMLstan]

That worked. I used ROUND function instead of TRIM function for the two cell values and the true/false statement returned a TRUE. Thank you.

 

[Michael M]

Glad it worked. TRIM is used for text not for numbers.
Also, have a read here for the benefits of rounding numbers in different ways....?

MROUND Function

The Excel MROUND function returns a number rounded to a given multiple. MROUND will round a number up or down, depending on the nearest multiple.

exceljet.net

 

[TMLstan]

Thanks. Yes, that was the reference article I found online after you directed me to the Round function.

Thanks again for your responsiveness.