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

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,974
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,382
Messages
5,444,129
Members
405,269
Latest member
Kjtakke

This Week's Hot Topics

Top