+ Reply to Thread
Results 1 to 3 of 3

Why result are diffrence by FLOOR and CEILING?

  1. #1
    Forum Contributor
    Join Date
    03-31-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    140

    Why result are diffrence by FLOOR and CEILING?

    Anyone can explain the result as following?
    Attached Images Attached Images

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,033

    Re: Why result are diffrence by FLOOR and CEILING?

    • FLOOR Rounds number down, toward zero, to the nearest multiple of significance.
    • CEILING Returns number rounded up, away from zero, to the nearest multiple of significance.

    since significance is 0.02 it's expected that this would be difference in output result for those two formula.
    Never use Merged Cells in Excel

  3. #3
    Forum Contributor
    Join Date
    03-31-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    140

    Re: Why result are diffrence by FLOOR and CEILING?

    If there are two difference output value by floor and ceiling, but why not all of them result will be FALSE?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Floor and ceiling functions
    By Parkerlad in forum Excel General
    Replies: 3
    Last Post: 11-03-2011, 08:58 AM
  2. FLOOR and CEILING functions
    By jalba in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-09-2009, 05:44 PM
  3. Something like CEILING or FLOOR
    By gusvenables in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-28-2005, 12:05 AM
  4. [SOLVED] ceiling & floor
    By Bill Ridgeway in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-07-2005, 10:05 AM
  5. ceiling and floor functions
    By JFamilo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2005, 11:13 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1