Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Formulas and calcualtions

  Asked By: Keon    Date: Oct 27    Category: Sharepoint    Views: 1003

Did y'all know about these built-in functions? I have been doing SP development for over 2 years and just came across this documentation. Seems it would be pretty helpful:
Each of these functions, referred to collectively as the IS functions, checks the type of value and returns TRUE or FALSE depending on the outcome. For example, the ISBLANK function returns the logical value TRUE if value is a column reference that is empty; otherwise it returns FALSE
ISBLANK Value refers to an empty column reference.
ISERR Value refers to any error value except #N/A.
ISERROR Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).
ISLOGICAL Value refers to a logical value.
ISNA Value refers to the #N/A (value not available) error value.
ISNONTEXT Value refers to any item that is not text. (Note that this function returns TRUE if value refers to a blank column reference.)
ISNUMBER Value refers to a number.
ISTEXT Value refers to text



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Formulas and calcualtions Or get search suggestion and latest updates.