Solved

If the statement

Posted on 2012-12-20

Microsoft Excel

2 solutions

238 Views

Last Modified: 2012-12-20

In cell H3, I3, J3 and K3 I have either a "Yes" or "No". In Cell L3 I want it to say "Yes" if any of the 3 say "Yes". If none say "yes" I want cell L3 to say "no". Any idea?

Comment

Question by:cansevin

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

3 Comments

LVL 6

Accepted Solution

by:traoher

traoher earned 250 total points

ID: 387115722012-12-20

in L3 cell, enter

=IF(AND(H3 ="yes",I3="yes",J3="yes"),"yes","no")

LVL 34

Assisted Solution

by:Norie

Norie earned 250 total points

ID: 387115812012-12-20

Try this.

=IF(COUNTIF(H3:J3, "yes")>0, "yes", "no")

LVL 34

Expert Comment

by:Norie

ID: 387117472012-12-20

cansevin

The formula in the accepted solution will only return 'yes' if every cell in H3:J3 has 'yes' in it.

Is that what you wanted?

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title	# Comments	Views	Activity
I would like to delete a cell in excel from which I think it has no use	2	31	2017-05-13
Recolor all specifically named pie charts using VBA	4	37	2017-05-07
Copy one row (from Word) into one cell	14	43	5d
Need VBA to color cell if 1st three numbers in Column C of Sheet1 match any of the numbers in Column A on Sheet2	22	44	2d

A Better Concatenate Function

Article by: aikimark

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful. I tested several solutions and share the results in this article as well as t…

Microsoft Excel

Automating Microsoft Excel from Access (Part I)

Article by: Dale Fye

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…

Building Probability Models in Excel Part 4: Discrete Random Variables

Video by: Toby

The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

Building Probability Models in Excel Part 6: Investment Modeling Using a Log-Normal Distritribution

Video by: Toby

The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…