If (sv1=True And sv2=True) then 1 Else If (sv1=True And sv2<> True) then 0 Else 1. The code I used is-
Code: Select all
If (sv1 AND sv2) Then 1 Else If (sv1 AND NOT(sv2)) Then 0 Else 1
Moderators: chulett, rschirm, roy
Code: Select all
If (sv1 AND sv2) Then 1 Else If (sv1 AND NOT(sv2)) Then 0 Else 1
Code: Select all
If (Not(IsNull((sv1)) AND Not(IsNull(sv2))) Then 1 Else If (Not(IsNull(sv1)) AND IsNull(sv2)) Then 0 Else 1
Code: Select all
If (sv1 AND sv2) Then 1 Else "" : (If (sv1 AND NOT(sv2)) Then 0 Else 1)