Board Thread:General Discussion/@comment-15636815-20131029040121/@comment-5596770-20131031023204

I haven't specifically looked at how they are coded for Wikia, but the point of FLOOR and CEILING are to round numbers in one direction. The easiest case is integer, and since that is how we would be using them, I'll use that for an example.

CEILING: Rounds decimal number UP to the nearest integer.

CEILING(3.2) = 4; CEILING(3.9) = 4; CEILING(8.000001) = 9

FLOOR: Rounds decimal number DOWN to the nearest integer.

FLOOR(3.2) = 3; FLOOR(3.9) = 3; FLOOR(8.9999999) = 8

I'd recommend opening Excel, or any other spreadsheet program, and playing around with their implementations for a couple minutes.

Keep in mind that FLOOR and CEILING don't cancel out. i.e. FLOOR( CEILING( 3.1 ) ) = 4; CEILING( FLOOR( 3.1) ) = 3