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?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,128
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:

Forum statistics

Threads
1,077,686
Messages
5,335,656
Members
399,032
Latest member
thefinu

Some videos you may like

This Week's Hot Topics

Top