Formula Function Reference

Our Formula Function Reference

Formula Function Reference

• 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 - 4: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 - 4:10 PM
Tags:
• Returns the first day of the month in which the date falls.
October 14th, 2009 - 4: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 - 4:10 PM
Tags:
• Returns the first day (Sunday) of the week in which the date falls.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the first day of the year in which the date falls.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the number of days by which the given date d follows the first day of the year (January 1 returns 0).
October 14th, 2009 - 4:10 PM
Tags:
• Returns a Duration representing n days. This function takes a number and converts it into a Duration type value, expressed in days.
October 14th, 2009 - 4:10 PM
Tags:
• Returns a Text value containing the database ID of a table.
October 14th, 2009 - 4:10 PM
Tags:
• Returns true if the text u ends with the text v, otherwise returns false.
October 14th, 2009 - 4:10 PM
Tags: