Formula Function Reference

Our Formula Function Reference

Formula Function Reference

  • This function returns x if x is not null. If it is null, it returns the alternate value y instead. Null means that a field's value is undefined. In other words, no one has entered any data in that particular field. It's empty. Its value is null.
    October 14th, 2009 - 4:10 PM
    Tags:
  • This function returns x if x is not null. If it is null, it returns the alternate value y instead.--Null means that a field's value is undefined. In other words, no one has entered any data in that particular field. It's empty. Its value is null.
    October 14th, 2009 - 4:10 PM
    Tags:
  • This function returns x if x is not null. If it is null, it returns the alternate value y instead.--Null means that a field's value is undefined. In other words, no one has entered any data in that particular field. It's empty. Its value is null.-
    October 14th, 2009 - 4:10 PM
    Tags:
  • This function returns x if x is not null. If it is null, it returns the alternate value y instead.--Null means that a field's value is undefined. In other words, no one has entered any data in that particular field. It's empty. Its value is null.-
    October 14th, 2009 - 4:10 PM
    Tags:
  • This function returns x if x is not null. If it is null, it returns the alternate value y instead. Null means that a field's value is undefined. In other words, no one has entered any data in that particular field. It's empty. Its value is null.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns true if either a or b is true, otherwise returns false.
    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:
  • Returns the last day before the given date d that falls on the weekday n. n is a number from 0 to 6 with Sunday being 0, Monday being 1, Tuesday being 2, and so on.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns what remains after excluding the leftmost n characters from the Text argument t.
    October 14th, 2009 - 4:10 PM
    Tags:
  • Returns what remains after excluding the left part of a text value up to and 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. 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:

© 1997-2014 Intuit Inc. All Rights Reserved.

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