Anyone can explain the result as following?
Anyone can explain the result as following?
- 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
If there are two difference output value by floor and ceiling, but why not all of them result will be FALSE?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks