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...

excel

Formulas and Functions

Haytham Amairah
Sep 26, 2018
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

Haytham Amairah

Silver Contributor

Sep 26, 2018

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

Hunter Adams

Copper Contributor

Sep 26, 2018

Thank you. That solved my issue.

Forum Discussion

Using IF and AND function