Formula Function Reference

Our Formula Function Reference

Formula Function Reference

  • Returns n characters from the middle of t, starting at position p. The first character is position 1.
    October 14th, 2009 - 3:10 PM
    Tags:
  • This function can take 2 or more arguments of any data type, as long as they are all the same type. The result is the same data type as the arguments. Null values are ignored. For Numbers, returns the argument that is least. For Text, returns the argument that sorts first alphabetically. For Durations, returns the argument that is shortest. For Dates returns the argument that is earliest. For Date/Time, returns the argument that is earliest. For TimeOfDays, returns the argument that is earliest. For Booleans returns the argument that is smallest, treating false as less than true.
    October 14th, 2009 - 3:10 PM
    Tags:
  • Returns the minute part of the argument t. The minute is in the range 0 to 59.
    October 14th, 2009 - 3:10 PM
    Tags:
  • Returns a Duration representing n minutes. This function takes a number and converts it into a Duration type value, expressed in minutes.
    October 14th, 2009 - 3:10 PM
    Tags:
  • Returns n modulo m. Mod implements 'clock' arithmetic; it models movement around a clock that is labeled with the numbers 0 to m-1. To get the result, just count n times around the clock. (Mod is the same as Rem for positive numbers, but different for negative numbers.) You might use this function to auto-assign tasks to staff members. For details, please read Article #308 in the QuickBase KnowledgeBase
    October 14th, 2009 - 3:10 PM
    Tags:
  • Returns the left part of a text value up to but not including the first 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 - 3:10 PM
    Tags:
  • Returns the number of characters in t.
    October 14th, 2009 - 3:10 PM
    Tags:
  • Concatenates (strings together) all arguments starting with the second argument, using the first argument as the delimiter between them. If one of the arguments is blank, it and the corresponding delimiter are omitted.
    October 14th, 2009 - 3:10 PM
    Tags:
  • Returns the natural (base e) logarithm of n.
    October 14th, 2009 - 3:10 PM
    Tags:
  • Returns the base 10 logarithm of n.
    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