I have a simple calculation and wonder for the result
=(314.4*100-30240)/60 return 20
=INT((314.4*100-30240)/60) return 19, is it correct? and why?
=INT((3144*10-30240)/60) return 20
thank you in advance
@Asterix: please don’t use “community wiki” checkbox. And don’t use “Answer” for what is not an answer to your question.
0.4 is not representable in base-2 floating-point representation: see
Floating-point arithmetic - Wikipedia.
When working with floating point arithmetic using computers, one must be prepared to such technical things, unfortunately.
Thank you very much sir