Calculation problem

[Filip88]

Hello,

i have quite interesting problem, which i did not expect at all...

I have couple of simple cells with formulas.

B1:1,0015
B2:1,0014
B3: B1-B2 = 0,00009999999

Excel result is 0,000099999, the problem is that i need to get result 0,0001 (1,0015-1,0014 = 0,0001) due to further calculations.

Is anyhow possible to set up excel to avoid "wrong" calculations with numbers with floating points?

thank you for help

Filip

 

[sheetspread]

Are those numbers rounded? If so they should return .0001. Otherwise add a round() function.

 

[JoeMo]

Try:
=ROUND(B1-B2 ,4)which will round your result to 4 decimal places

 

[Filip88]

Thank you, it works