If Statement

[dbaphomet]

First I want apologize for what maybe the obvious, but I'm struggling with a formula and I just can't find the resolution.

My question is "How can I reference text conditions in one column, time conditions in another, and put out the True/False statement using an if function?"

Example would be

If Column B2/B3/B4 contains:

Widgets:
Apples:
Oranges:

And Column C2/C3/C4 contains time values:

00:15:23
01:12:23
00:05:56

The Condition would be if B2="'Widgets", and C2>time(0,15,0),"Pass","", AND if B2='"Apples'", and C2<time(0,12,0),"fail" and so on.

I just can't get work right. Any help is greatly appreciated.

 

[dbaphomet]

The table option is a extreme time saver. Thanks for this. Very very much appreciated !!!