Mariner-software Mariner Write for Mac Manual de usuario Pagina 164

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 165
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 163
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
Vista de pagina 163
1 2 ... 159 160 161 162 163 164 165

Comentarios a estos manuales

Sin comentarios