Mariner-software Mariner Write for Mac Instrukcja Użytkownika Strona 164

  • Pobierz
  • Dodaj do moich podręczników
  • Drukuj
  • Strona
    / 165
  • Spis treści
  • BOOKMARKI
  • Oceniono. / 5. Na podstawie oceny klientów
Przeglądanie stron 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
Przeglądanie stron 163
1 2 ... 159 160 161 162 163 164 165

Komentarze do niniejszej Instrukcji

Brak uwag