Search: | |||||

| ||||

Home » Forum » Sharepoint | RSS Feeds |

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

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

Related Topics:

- Formulas and calculations
- Formulas for Lookup
- Setting the formula of a calculated field using the Object Model
- Help with WSS 3.0 formulas
- Filter formula in a doc lib. view
- Column IF formulas only nest seven deep.
- Excel Formulas
- Using formulas in sharepoint
- How can I build a longer (7>)calculated formula using the =IF function
- xsl formula not working right
- Convert excel formula to xsl for use in data form web part
- Formula
- Calculated column formula
- Filter formula in a doc lib. view
- Conditional Logic in Infopath formula controls
- Need help writing a formula for WSS 3.0
- Calculated Column using =LEFT() formula
- No Formula Bar in Excel Web Part
- Excel Formula in SharePoint Calculated Field/Column
- Calculated column - problem with formula
- 'The formula contains a syntax error or is not supported' Error
- Unable to update a the default formula of a calculated field?