Help with IF formula

aphillips212

New Member
Joined
Nov 13, 2019
Messages
1
I am trying to develop an IF formula. I have 4 cells with eother "yes" or "no" in them. I would like a formula that looks at the 4 cells and returns a message in another cell of "test" when 2 or more of the cells have "yes" in them. Can anyone assist me?
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,156
Office Version
365
Platform
Windows
Welcome to the Board!

Use a COUNTIF formula to count how many times "yes" occurs, and wrap that in an IF statement, i.e.
Code:
=IF(COUNTIF(A1:D1,"yes")>=2,"test","")
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,089,938
Messages
5,411,381
Members
403,363
Latest member
gooduser

This Week's Hot Topics

Top