Our Formula Function Reference

## Formula Function Reference

## Formula Function Reference

- Returns the largest multiple of y which is less than or equal to x.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 38906 reads

- Returns the largest multiple of the duration y which is less than or equal to the duration x.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 31614 reads

- Returns the fractional part of the Number n. The result is the same sign as n. For any Number n, Int(n) + Frac(n) is the same as n.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 31623 reads

- Returns the hour part of the argument t. The hour is in the range 0 to 23.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 32330 reads

- Returns a Duration representing n hours. This function takes a number and converts it into a Duration type value, expressed in hours.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 32473 reads

- If condition1 is true, returns result1, otherwise returns else-result. You can include additional condition/result pairs before the final else-result (as in the first example). QuickBase evaluates the conditions in sequence until one is found to be true, and then the corresponding result is returned. The else-result is optional. If omitted, QuickBase assumes it's null (or empty - a blank). All conditions must be of type Boolean (return a true or a false). Results may be of any type, but they must all be the same type.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 38109 reads

- Returns the integer part of Number n. Note that if n is a negative fraction, the result is closer to 0 than n is (compare to function Floor).October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 33064 reads

- Returns true if the date d falls in a leap year.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 31915 reads

- Returns true if the year y is a leap year.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 32194 reads

## Browse by Category

### Knowledge Base Categories

- Accounts (31)
- Application (57)
- E-Mail (7)
- Fields (38)
- Forms (18)
- Formulas (18)
- General (72)
- Other Product (7)
- Pages (1)
- Product (5)
- Reports (14)
- Roles (4)
- Search (1)
- Tables (5)

### Formula Category

about_http_API
access
account
add
API
APIs
application
applications
automatically
backup
billing
buttons
change
copy
email
error
export
field
fields
form
formula
formulas
formula URL
http_api
IP
issues
limit
limits
multiple
page
password
patches
plan
QuickBase
records
Release Notes
release notes
remove
report
reports
SDK
security
September 30
software
space
status
user
users
video
view