Mariner Software Mariner Write for Mac - Manual (Page 164)

Format: =OR(condition 1, condition 2, ...)!
Example Data:!
=OR(First="James", Last="Paar") equals 1!
Explanation - field First equals James and field Last equals Paar, all conditions are true, the function returns
1 (true)!
=OR(First="Bill", Last="Paar") equals 1!
Explanation - field First does not equal Bill and field Last equals Paar, one condition is true and the function
returns 1 (true)!
=OR(First="Bill", Last="Jones") equals 0!
Explanation - field First does not equal Bill and field Last does not equal Jones, all conditions are false and
the function returns 0 (false)!
=OR(First="", Last="")!
Explanation - field First does not equal "" and field Last does not equal "", all conditions are false and the
function returns 0 (false)!
=IF(OR(First="", Last=""),ERROR(),"")!
Explanation - the IF function uses the OR result to determine if this Data record has valid names.!
The OR function returns 0 (false), the IF function evaluates and returns the false value which does nothing
("" is an empty placeholder).!
If your data did not have a First or Last name, the IF function would return the ERROR function and stop the merge.
of 164 165