floating point - Calculation problem in Java

Question

I'm having slight difficulty in performing a calculation in Java. Here is what I'm trying to do -

((0.053800 * (500000/1000)) + 4) * 0.85

In my java application, it returns 26.264999999999997, which if you round up to 2 decimal places, becomes 26.26.

But in MS Excel, the same formula returns 26.265000.. and therefore the rounded result is 26.27.

If my Java application is returning incorrect value, what can I do to correct it?

Answer 1

See my answer here for an explanation of what's going on.