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?

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][/tr][tr][td]

1​

[/td][td]1. Agree[/td][/tr]
[tr][td]

2​

[/td][td]1. Agree[/td][/tr]
[tr][td]

3​

[/td][td]4. N/A[/td][/tr]
[tr][td]

4​

[/td][td]3. Disagree[/td][/tr]
[tr][td]

5​

[/td][td]1. Agree[/td][/tr]
[/table]