Hi, I have a problem with my IF condition. Sc...

Hi, I have a problem with my IF condition. Scenario, I want my apps to count the total visit to a certain places of interest based on email. So, I put this IF command inside the Virtual table:

=IF(AND([Visited?]=Visited, [Email]=USEREMAIL(), Yes,No))

but got this error:

Condition AND(([Visited?] = โ€œVisitedโ€), ([Email] = USEREMAIL()), โ€œYesโ€, โ€œNOโ€) has an invalid structure: subexpressions must be Yes/No conditions

Pls help. Tq in adv.

0 2 344
2 REPLIES 2
Top Labels in this Space