The AND function

TRUE only if every test is true.

In German Excel: UND

How to write it

=AND(logical1, [logical2], …)

logical1: The first test.
logical2: More tests.

💡 Use it inside IF: =IF(AND(a,b),"Yes","No").

Try it

Is Priya in Sales and has 5 or more years?

E4

A

B

C

D

E

1

Name

Team

Salary

Years

Senior sales?

2

Nora

Sales

52000

3

3

Omar

Support

41000

1

4

Priya

Sales

61000

6

5

Quinn

Tech

72000

4

6

Rosa

Support

39000

2

7

Sven

Tech

80000

8

=AND(test one, test two).