Is it a bug? Simple math with weird result. c3p provided

Hi, the problem is simple. As you can see below, that is weird and it's giving me even more weird results in my main project. Am I high? c3p: drive.google.com/file/d/11S2bQsb0jEzPCe77zoOTxEuunbJJlR-V/view

This has been discussed many times before. Computers can't represent floating point numbers accurately - it doesn't matter how "simple" they may seem.

https://en.wikipedia.org/wiki/Floating-point_arithmetic

If you don't actually need floating point, try to keep your numbers as integers, and scale them to floating point at the last moment when really needed. (That is, multiply by 10 initially, and divide by 10 latter, for example).

So I need to scale them to integer before calculation? Would be ok to store them as floating numbers?

I couldn't open your file to see what you are doing, but I'd keep things at integers as long as I could.

Thanks. I've scaled up all my data to integers and I'm only using floating numbers in the calculations. I just don't know the best approach to this problem if we face a scenario where we just can't avoid them. Because, if we store them, for instance 0.6, and multiply by 10, the result would be 6.000000000000001. For that we can use floor but would need to count the decimals to know if it's 10, 100, etc . That's too much work for simple calculations, which brings me the question: do you know what's the most common approach for this situation?