Spread WPF Documentation
Spread WPF Documentation / Formula Reference / Formula Functions / OR
In This Topic
    OR
    In This Topic

    Summary

    This function calculates logical OR. It returns TRUE if any of its arguments are true; otherwise, returns FALSE if all arguments are false.

    Syntax

    OR(bool1,bool2,...)

    OR(array)

    OR(array1,array2,...)

    OR(expression)

    OR(expression1,expression2,...)

    Arguments

    Provide numeric (1 or 0) or logical values (TRUE or FALSE) for up to 255 arguments. You can also specify a single array instead of listing the values separately, or up to 255 arrays. Similarly, you can specify an expression or up to 255 expressions.

    Data Types

    Accepts logical data (Boolean values of TRUE or FALSE) or numerical values (0 or 1). Returns logical data (Boolean values of TRUE or FALSE).

    Examples

    OR(B3,B6,B9)

    OR(R1C2,R1C3,R1C4,R1C5)

    OR(D2:D12)

    OR(R12C1:R12C9)

    OR(TRUE,FALSE,FALSE) gives the result TRUE

    OR(TRUE()) gives the result TRUE

    OR(FALSE(),FALSE()) gives the result FALSE

    OR(1+1=1,2+2=5) gives the result FALSE

    OR(5+3=8,5+4=12) gives the result TRUE

    See Also