Our Formula Function Reference

## Formula Function Reference

## Formula Function Reference

- 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.
- Add new comment
- 52267 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.
- Add new comment
- 51617 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.)
- Add new comment
- 53955 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.)
- Add new comment
- 53679 reads

- Returns the multiple of the duration y which is nearest the duration x.
- Add new comment
- 52447 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.

- Add new comment
- 66252 reads

- Returns the nearest integer to the number x. The fraction .5 rounds up to the next greater integer.
- Add new comment
- 58942 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.
- Add new comment
- 71210 reads

- Returns the rightmost n characters from the Text argument t.
- Add new comment
- 53076 reads

- This function returns x if x is not null. If it is null, it returns the alternate value y instead.--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.
- 2 comments
- 53453 reads