formula

Syndicate content
Returns a Duration representing n seconds. This function takes a number and converts it into a Duration type value, expressed in seconds.
October 14th, 2009 - 4:10 PM
Tags:
Returns the square root of n.
October 14th, 2009 - 4:10 PM
Tags:
Returns the sum of the non-null arguments.
October 14th, 2009 - 4:10 PM
Tags:
Returns the sum of the non-null arguments.
October 14th, 2009 - 4:10 PM
Tags:
Converts the values "1", "true" or "yes" to true, other values to false. Case is ignored.
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 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 multiple of the duration y which is nearest the duration x.
October 14th, 2009 - 4:10 PM
Tags:
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:

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit