Our Formula Function Reference

## Formula Function Reference

## Formula Function Reference

- Returns the nearest integer to the number x. The fraction .5 rounds up to the next greater integer.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 62975 reads

- Returns the right part of a text value starting at the character after the last occurrence of a delimiter character. The first argument, t, is the value to be searched. The second argument, d, is a text value containing all the possible delimiter characters.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 75471 reads

- Returns the rightmost n characters from the Text argument t.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 56529 reads

- Calculates the Present Value of a future payment. Rate is the discount rate for one time period. Nskip is the number of time periods before the payment occurs. Amt is the amount of the payment.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 55419 reads

- Calculates the Present Value of a series of future payments. Rate is the discount rate for one time period. Nskip is the number of time periods before the first payment occurs. Amt is the amount of each payment. Npay is the number of payments in the series, spaced one time period apart.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 54992 reads

- Returns a number that is the remainder after n is divided by d an integer number of times. (Mod is the same as Rem for positive numbers, but different for negative numbers.)October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 56784 reads

- Returns a Duration that is the remainder after n is divided by d an integer number of times. (Mod is the same as Rem for positive numbers, but different for negative numbers.)October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 56941 reads

- Returns the multiple of the duration y which is nearest the duration x.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 55866 reads

Returns the multiple of y which is nearest to x.

You may notice small discrepancies when you use this function with floating point numbers. For example, Round(37.785,0.01) returns 37.78 instead of 37.79. This is not a QuickBase-specific issue; the discrepancies happen because some floating point numbers cannot be represented exactly in the binary format required by computers and are instead approximated.

October 14th, 2009 - 4:10 PMTags:- Add new comment
- 71344 reads

- This function returns d if d is not null. If it is null, it returns a 0-length duration instead. An undefined or empty field is "null." Null values don't work in calculations, which is where the Nz() function comes in handy. When Nz() finds a null, it sees it as a zero. So, if you want to perform calculations on a field that may include a null, use the Nz function.October 14th, 2009 - 4:10 PMTags:
- Add new comment
- 59380 reads

## Browse by Category

### Knowledge Base Categories

- Accounts (29)
- Application (54)
- E-Mail (7)
- Fields (40)
- Forms (19)
- Formulas (19)
- General (66)
- Other Product (7)
- Pages (1)
- Product (4)
- Reports (15)
- Roles (4)
- Search (1)
- Tables (5)

### Formula Category

about_http_API
access
add
API
APIs
application
automatically
back up
backup
billing
buttons
change
copy
email
error
export
field
fields
form
formula
formulas
formula URL
http_api
internet
IP
issues
limit
limitation
limits
page
password
patches
plan
QuickBase
reached
records
Release Notes
remove
report
reports
SDK
September 30
size
space
status
table
upgrade
user
users
view