Forum Discussion
Solved
Using IF and AND function
Here is my problem: The logical test in the IF function should determine if the staff members Service Years is greater than 4 AND the staff members Leadership Training status is "Yes". Use structure...
Hi Hunter,
The first logical test in the AND function is not right!
You should replace this:
=IF(AND([@[Service Years]]>4="Yes",[@[Leadership Training]]="Yes"),"Yes","No")
With this:
=IF(AND([@[Service Years]]>4,[@[Leadership Training]]="Yes"),"Yes","No")
Hope this helps you
Regards
Hi Hunter,
The first logical test in the AND function is not right!
You should replace this:
=IF(AND([@[Service Years]]>4="Yes",[@[Leadership Training]]="Yes"),"Yes","No")
With this:
=IF(AND([@[Service Years]]>4,[@[Leadership Training]]="Yes"),"Yes","No")
Hope this helps you
Regards
Thank you. That solved my issue.
