Set of conditions that outputs specific value between a range of cells.

[timsharper]

Hi,

This might be a bit wordy so I apologise in advance.

Basically, I have a set of data where a range of cells display either "1. Agree", "2. Agree with Recommendations" or "3. Disagree".

For concreteness, let's assume that these are in A1:A5.

Essentially, I would like cell A6 to display one of "1. Agree", "2. Agree with Recommendations" or "3. Disagree" based on the following conditions:

- Display "1. Agree" if All cells A1:A5 are "1. Agree"

- Display "2. Agree with Recommendations" if at-least one cell is "2. Agree with Recommendations" and/or there are up to two "3. Disagree"'s between the cells A1:A5.

- Display "3. Disagree" if three or more cells in A1:A5 contain "3. Disagree".



I'm not sure whether this is a job for multiple COUNTIF's?

Any help would be appreciated! - Let me know if you have any questions!

Thanks,

Tim

 

[Aladin Akyurek]

Thanks...

What is the conclusion if you have the following?

Row\Col	A​
1​	1. Agree
2​	1. Agree
3​	4. N/A
4​	3. Disagree
5​	1. Agree