http://www.zorba-xquery.com/modules/excel/logical ZC

Module Description
Before using any of the functions below please remember to import the module namespace: 
import module namespace excel-logical = "http://www.zorba-xquery.com/modules/excel/logical";

This is a library module offering the same set of functions defined by Microsoft Excel, under Logical Functions.

Author:

Sorin Nasoi

XQuery version and encoding for this module:

xquery version "1.0" encoding "utf-8";

Module Resources
  • the XQuery module can be found here.
Related Documentation

For more details please also see:

Namespaces
excel-err http://www.zorba-xquery.com/modules/excel/errors
excel-logical http://www.zorba-xquery.com/modules/excel/logical
ver http://www.zorba-xquery.com/options/versioning
Function Summary
and ( $values as xs:anyAtomicType* ) as xs:boolean
Returns TRUE if all its arguments are TRUE; FALSE if one or more arguments are FALSE.
and ( $arg1 as xs:anyAtomicType, $arg2 as xs:anyAtomicType ) as xs:boolean
Returns TRUE if all its arguments are TRUE; FALSE if one or more arguments are FALSE.
if ( $logical_test as xs:boolean, $value_if_true as item()*, $value_if_false as item()* ) as item()*
Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.
or ( $values as xs:anyAtomicType* ) as xs:boolean
Returns TRUE if any argument is TRUE; FALSE if all arguments are FALSE.
or ( $arg1 as xs:anyAtomicType, $arg2 as xs:anyAtomicType ) as xs:boolean
Returns TRUE if any argument is TRUE; FALSE if all arguments are FALSE.
Functions
and back to 'Function Summary' 
declare function excel-logical:and (
            $values as xs:anyAtomicType* 
 ) as xs:boolean

Returns TRUE if all its arguments are TRUE; FALSE if one or more arguments are FALSE.

Parameters:
  • $values the sequence of arguments.
Returns:
  • TRUE if all its arguments are TRUE; FALSE if one or more arguments are FALSE.
Errors:
  • excel-err:Value provided sequence is empty.
See:
and back to 'Function Summary' 
declare function excel-logical:and (
            $arg1 as xs:anyAtomicType, 
            $arg2 as xs:anyAtomicType 
 ) as xs:boolean

Returns TRUE if all its arguments are TRUE; FALSE if one or more arguments are FALSE.

Parameters:
  • $arg1 the first argument.
  • $arg2 the second argument.
Returns:
  • TRUE if all its arguments are TRUE; FALSE if one or more arguments are FALSE.
See:
if back to 'Function Summary' 
declare function excel-logical:if (
            $logical_test as xs:boolean, 
            $value_if_true as item()*, 
            $value_if_false as item()* 
 ) as item()*

Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.

Parameters:
  • $logical_test is any value or expression that can be evaluated to TRUE or FALSE.
  • $value_if_true the value that is returned if logical_test is TRUE.
  • $value_if_false the value that is returned if logical_test is FALSE.
Returns:
  • One value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.
See:
or back to 'Function Summary' 
declare function excel-logical:or (
            $values as xs:anyAtomicType* 
 ) as xs:boolean

Returns TRUE if any argument is TRUE; FALSE if all arguments are FALSE.

Parameters:
  • $values the sequence of arguments.
Returns:
  • TRUE if any argument is TRUE; FALSE if all arguments are FALSE.
Errors:
  • excel-err:Value provided sequence is empty.
See:
or back to 'Function Summary' 
declare function excel-logical:or (
            $arg1 as xs:anyAtomicType, 
            $arg2 as xs:anyAtomicType 
 ) as xs:boolean

Returns TRUE if any argument is TRUE; FALSE if all arguments are FALSE.

Parameters:
  • $arg1 the first argument.
  • $arg2 the second argument.
Returns:
  • TRUE if any argument is TRUE; FALSE if all arguments are FALSE.
See:
blog comments powered by Disqus