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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,171
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,090,228
Messages
5,413,204
Members
403,466
Latest member
sammv

This Week's Hot Topics

Top