Floor & Ceil (RPN-67 vs Excel)

[stilmant]

Hi Again,

What I'm wondering is if you may have used the Round-Toward-Zero algorithm while you were expecting Round-Floor results. Microsoft Excel was designed around the IEEE 754 specification for storing and calculating floating-point numbers. This standard proposes multiple ways of rounding:Directed roundings Could it be that this is why Excel includes multiple modes in the same floor function?

Thomas was warning exactly about that in his comment.

Here's a nice summary of different rounding algorithms, which might help answer your original question ("why would there be a difference?"):


Edit: Source of the Pic + add Thomas Okken credit.