Post Reply 
Floor & Ceil (RPN-67 vs Excel)
05-24-2024, 10:40 AM (This post was last modified: 05-24-2024 10:41 AM by dm319.)
Post: #4
RE: Floor & Ceil (RPN-67 vs Excel)
I think Microsoft Excel has it wrong.

This is what wikipedia says at the bottom of their page:

Wikipedia Wrote:In Microsoft Excel the funtion INT rounds down rather than toward zero,[52] while FLOOR rounds toward zero, the opposite of what "int" and "floor" do in other languages. Since 2010 FLOOR has been changed to error if the number is negative.[53] The OpenDocument file format, as used by OpenOffice.org, Libreoffice and others, INT[54] and FLOOR both do floor, and FLOOR has a third argument to reproduce Excel's earlier behavior.[55]
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Floor & Ceil (RPN-67 vs Excel) - dm319 - 05-24-2024 10:40 AM
RE: Floor & Ceil (RPN-67 vs Excel) - dm319 - 05-24-2024, 07:45 PM



User(s) browsing this thread: 6 Guest(s)