Floor & Ceil (RPN-67 vs Excel)

[stilmant]

Hi Matt,

Regarding why Excel might be perceived as the "official word," it's likely due to its widespread use and market dominance, as you mentioned. However, widespread use does not always equate to mathematical correctness. Users need to be cautious and understand the limitations of Excel's functions.

I noticed that you didn't provide some details of your tests. I don't understand the "It took this dual sided investigation" mentioned, but I would like to clarify that Excel has two floor functions:

• FLOOR function
• FLOOR.MATH function
  

The FLOOR.MATH function offers two modes, one of which is optional. The mode specifies the direction (toward or away from 0) to round negative numbers.

So, there are at least three ways to get floor results in Excel, and you mentioned "max mode," which also confuses me.

It would be helpful to know more about the specific examples where you see the -1 discrepancy. This might help pinpoint exactly where the differences arise and further clarify the behavior of both Excel and RPN-67.

Thanks!

Michael