it could be a rounding error with the decimal places - are you typing in
cells b3 & b4 or do they come form another formula?
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"JB2010" wrote:

hi

i have a column of figures i am trying to balance, visually they match but i
cant get the formula to read it that way.


the sheet is laid out like this

A B
1 Title $
2 Pre-X 3507.55975
3 Mid-X -1154.193125
4 Post-X 0.00000
5 Total 2353.366625


to reconcile the figure in cell B4, i have this formula in cell B6;


=IF(B4=B5-B3-B2,TRUE,FALSE)

this should work fine, but it comes up saying FALSE

this is doing my head in!


if i break the IF formula down & put cell D1 as;

=B4


& cell D2 is;

=B5-B3-B2



& then put this in cell D3;


=Exact(D1,D2)


it comes up as TRUE


so the numbers DO actually match (as you would expect!!!), why then is my IF
function mucking about?



has anybody come across this before? i am think this maybe has something to
do with it reading zeros differently?


any help gratefully recieved


cheers

jb