formula

Syndicate content
Returns a Duration representing n hours. This function takes a number and converts it into a Duration type value, expressed in hours.
October 14th, 2009 - 3:10 PM
Tags:
If condition1 is true, returns result1, otherwise returns else-result. You can include additional condition/result pairs before the final else-result (as in the first example). QuickBase evaluates the conditions in sequence until one is found to be true, and then the corresponding result is returned. The else-result is optional. If omitted, QuickBase assumes it's null (or empty - a blank). All conditions must be of type Boolean (return a true or a false). Results may be of any type, but they must all be the same type.
October 14th, 2009 - 3:10 PM
Tags:
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 - 3:10 PM
Tags:
Returns true if d is February 29.
October 14th, 2009 - 3:10 PM
Tags:
Returns true if the date d falls in a leap year.
October 14th, 2009 - 3:10 PM
Tags:
Returns true if the year y is a leap year.
October 14th, 2009 - 3:10 PM
Tags:
Returns e raised to the nth power, where e is approximately 2.71828182845905 This exponential function is for use in logarithmic calculations that track growth. For example, you can use it to figure compounding interest.
October 14th, 2009 - 3:10 PM
Tags:
Returns the first day of the month in which the date falls.
October 14th, 2009 - 3:10 PM
Tags:
Returns the first day of the period in which the date d falls. The cycle of periods is defined by the given Duration p, repeated in sequence starting at the given reference date r. If the period p is not a whole number of days, the fractional part is ignored.
October 14th, 2009 - 3:10 PM
Tags:
Returns the first day (Sunday) of the week in which the date falls.
October 14th, 2009 - 3:10 PM
Tags:

© 1997-2014 Intuit Inc. All Rights Reserved.

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