If function causing 'accuracy' problem

[GuyE]

I placed a question here yesterday and I guess It wasn't clear enough. I am attaching an excel sheet example but In case it doesn't show up properly, I will describe my problem. I have two identical cells B8=C5, both with positive values. in addition I have a positive value in cell C4. I wrote the following formula in cell C6: "=IF(C4>0,C5-B8,0)". since C5=B8, C5-B8=0, therefore the only solution to the formula has to be 0. for some reson I am receiving a n answer close to 0 but not accurat )9.09494701772928E-13). WHY?
Please see the displayes sheet.
Cell C6 returns an unwanted answer using "IF".
Cell C7 returns the 'proper' answer.
Why aren't the answers identical?

Book2.xls
	A	B	C	D	E
4	condition		8000
5	Openingbalance	5067	5067
6	using"if"function		9.09495E-13
7	the'required'answerofthe"if"function		-
8	closingbalance	5067	5067
Sheet1

Thanks for any help here. and sorry again for not being clear yesterday

 

[Andrew Poulsom]

I can't reproduce that given what you have posted.

What's in C5, B8, C6 and C7 when formatted as General? Floating point arithmetic can return very small numbers instead of zero when subtracting.

 

[Oaktree]

Is it just a formatting issue? What if you copy the format from C7 to C6?