302 Found

Found

The document has moved here.

Formula Function Reference

Our 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.
    October 14th, 2009 - 4:10 PM
    Tags:
  • 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 PM
    Tags:
  • 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 PM
    Tags:
  • 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 PM
    Tags:
  • Returns the multiple of the duration y which is nearest the duration x.
    October 14th, 2009 - 4:10 PM
    Tags:
  • 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 PM
    Tags:
  • Returns the nearest integer to the number x. The fraction .5 rounds up to the next greater integer.
    October 14th, 2009 - 4:10 PM
    Tags:
  • 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 PM
    Tags:
  • Returns the rightmost n characters from the Text argument t.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns the specified part of a text value. The parts are separated by the occurrence of any delimiter character. The first argument, t, is the value to be searched. The second argument, p, is the position of the part in the argument t. The first part starting on the left is position 1. Negative part numbers can be used to start from the right. The third argument, d, is a text value containing all the possible delimiter characters. If space is included in the delimiter list it is handled specially. It acts as a delimiter, but contiguous spaces surrounding a delimiter are ignored rather than each acting as a separate delimiter.
    October 14th, 2009 - 4:10 PM
    Tags:
302 Found

Found

The document has moved here.