formula

Syndicate content
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 - 3: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 - 3:10 PM
Tags:
Returns the nearest integer to the number x. The fraction .5 rounds up to the next greater integer.
October 14th, 2009 - 3:10 PM
Tags:
Returns the multiple of the duration y which is nearest the duration x.
October 14th, 2009 - 3: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 - 3:10 PM
Tags:
This function returns d if d is not null. If it is null, it returns a 0-length duration instead. An undefined or empty field is "null." Null values don't work in calculations, which is where the Nz() function comes in handy. When Nz() finds a null, it sees it as a zero. So, if you want to perform calculations on a field that may include a null, use the Nz function.
October 14th, 2009 - 3: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 - 3: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 - 3: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 - 3: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 - 3:10 PM
Tags:

© 1997-2014 Intuit Inc. All Rights Reserved.

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