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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,043
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,095,789
Messages
5,446,502
Members
405,404
Latest member
clead

This Week's Hot Topics

Top