AnsweredAssumed Answered

Help using an 'AND' in a formula

Question asked by RachelJacobsen on Aug 29, 2012
Latest reply on Aug 29, 2012 by Sorbsbuster

Title

Help using an 'AND' in a formula

Post

This works:

If ((Table1::type)="TypeOfLetter"; "Attempted to give the "& Letter1 & ". " & " Knocked on the door, no one answered. Therefore, the " & Letter1 &  " was mailed to " & PersonMailedTo & " on " & DateMailed & ".")

I want to add another condition: 

If ((Table1::type)="TypeOfLetter" and if (Table2::Type); "Attempted to give the "& Letter1 & ". " & " Knocked on the door, no one answered. Therefore, the " & Letter1 &  " was mailed to " & PersonMailedTo & " on " & DateMailed & "."))

 

Any ideas where I can get some samples using multiple conditions

Outcomes