Definition and Syntax
• FLOOR rounds a number down to the nearest number of significance, toward zero.
How to Use It
• Simply rounding the result of a division or multiplication is all well and good in the elastic world of pure numbers, but not always useful if you’re working on tangible things. Say you have 86 text pages and want to know how many 32-page signatures you can print. Excel would round up the answer to the whole number 3, but there aren’t three full 32s in there, only 2.625.
• FLOOR solves the problem by rounding down to the significance you specify. FLOOR(86/32,1) equals 2. That pesky .625 remainder is tossed aside. (The companion function, CEILING, rounds up.)
• To understand the significance value, note that FLOOR(86/32,0.5) will equal 2.5—it will round down to halves with a 0.5 significance.
When to Use It
To make a table that determines all the signatures for any page count, start by making a variable for true 16s, 8s or 4s. If you need to designate inefficient signature usage in order to better mimic actual practice, you can enter the number of 4s, 8s or 16s you want to be sure to print, without regard to imposition efficiency. The sequence of the table goes like this:
• Subtract the pages set aside in True16s, True8s and True4s from the page count.
• Define the test-signature size (the table starts with the largest size available: 64s, 48s or 32s, and then works downward on subsequent iterations).
• Calculate the number of that signature size to use, with FLOOR.
• Calculate the number of text pages consumed, by multiplying the number of signatures by the signature pages and subtracting this from the total page count.
• Determine the remaining pages available by subtracting the pages consumed and the pages in the True16s, etc.