Our Formula Function Reference

## Formula Function Reference

## Formula Function Reference

- 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
- 33047 reads

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

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

- Null means that a field's value is undefined. In other words, no one has entered any data in that particular field. It's empty. Its value is null.--The result of this function is true if x is null, otherwise false. The argument x may be of any data type (except text or boolean).October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 43241 reads

- Returns true if x is the email address of the current user.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 32116 reads

- Returns the largest integer less than or equal to the number x. Note that if x is a negative fraction, the result is closer to negative infinity than x is (compare to function Int).October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 32754 reads

- Returns the largest multiple of y which is less than or equal to x.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 38874 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
- 31597 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
- 31606 reads

## Browse by Category

### Knowledge Base Categories

- Accounts (31)
- Application (57)
- E-Mail (7)
- Fields (38)
- Forms (18)
- Formulas (18)
- General (71)
- 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