If Formula

[eramirez148]

I need a formula that will give me the following results in column D. If there is multiple cells with in column A and column B and C show active for any of the repetative cells or non repetative cells then the results should be "OK." If there are repetitive cells on non repetitive cells in column A and column B and C are empty then the result should be "OK."

Otherwise the results should be "Violation."

	A	B	C	D
1	Protein Yogurt	Active	Active	OK
2	talian Beef	Active	Active	OK
3	Chicken Drum	Active		Violation
4	Chicken Drum	Active		Violation
5	Chicken Drumsticks	Active		Violation
6	Trail Mix	Active		OK
7	Trail Mix	Active	Active	OK
8	Grains Chicken	Active	Active	OK
9	Popcorn	Active	Active	OK
10	Red Pepper	Active	Active	OK
11	Buns	Active	Active	OK
12	Peaches			OK
13	Orange			OK
14	orange			OK

 

[Joe4]

Duplicate to: If Formula

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.