Category: Number
Syntax: Ceiling ( number ) |
Parameters:
numberAny expression that resolves to a numeric value.
Data type returned: Number
Description:
Returns number rounded up to the next integer.
One common use for the Ceiling function is finding out how many pages will be required to print x items if y items fit on a page. The formula for this is Ceiling ( x / y ). For instance, if you have 16 items, and 5 can print per page, you would need Ceiling ( 16/5 ) = Ceiling ( 3.2 ) = 4 pages.
Examples:
Ceiling ( 1.05 ) = 2 Ceiling ( -4.6 ) = -4 Ceiling ( 3 ) = 3
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
Calculation Signatures
Calculation Functions
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Scripting Primer
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information