Formula to review multiple columns for three values and provide yes or no

[Wanttobeexcelpro]

Hello,

I want to review columns B, C, and D and return a value of yes or no if it contains three values that match the following.
Payment type= Withdrawal in column B
Year= 2020 in Column C
Amount <-11

I only want one yes or no, not multiple yes or nos for each row. e.g. Withdrawal made in 2020 (yes) or (No)

I've attached a sample.

[dosydos]

try this in E2:

=IF(AND(B2="WITHDRAWAL",C2=2020,D2<-11),"Yes","No")

[Wanttobeexcelpro]

Thank you but I'd like to only report one value after reviewing all columns e.g. review multiple columns for the specific criteria vs. individual cells.

[dosydos]

is MS enterprise the same thing as MS 365?

[dosydos]

well if you have MS 365 then the below formula i believe is what you are looking for:

Please Login or Register  to view this content.

[dosydos]

if you don't have Office 365 you could use this instead:

Please Login or Register  to view this content.

[Wanttobeexcelpro]

I've tried both and they both provide No when it should be yes.

[dosydos]

with the sample you provided there are only 3 rows out of the 500+ that are Withdrawal. Of those 3 only 1 is 2020 and is less than -11 so the answer should be "No". According to your original query you wanted it to show yes if there were 3 or more entries that met your criteria. If i change the data you supply so there are 3 WITHDRAWAL with a year of 2020 and less than -11 then my formula returns Yes.