Formula Help: multiple cells with a < or > then Return statement

[ldavis1227]

I want to know if any of the values in (I1, J1, K1) is (< then L1) return "Yes", if (> then L1) return "No".

I1 = .02
J1 = .08
K1 = 1.13
L1 = 0

Of note: each of these cell have a formula behind them also and the value will change.

 

[ldavis1227]

Can you tell me how to fix the formula to account for All instead of Any?

 

[Jonmo1]

Try

=IF(MAX(I1:K1) < L1,"Yes","No")

 

[ldavis1227]

can you tell me how to fix my formula to look at "all" instead of "any"?

=IF(OR(I5 >= L5, J5 >= L5, K5 >= L5), "No", "Yes")

 

[Jonmo1]

You could just change OR to AND

 

[ldavis1227]

I didn't think my other one posted. Sorry I posted again. You're formula still didn't work for me. if my columns I:K are within the TAT of L it still says "No" it should be "Yes"

 

[ldavis1227]

I downloaded the Jeanie, here is what I'm working with.

Sheet1

	A	B	C	D	E
1	TAT for F3	TAT for G3	TAT for H3	TAT Req	Issue with TAT?
2	1	4	12	14	Yes
3	4	9	31	30	Yes

<colgroup><col style="width: 30px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula E2 =IF(AND(A1 >= D1, B1>= D1, C1 >= D1), "No", "Yes") E3 =IF(AND(A2 >= D2, B2>= D2, C2 >= D2), "No", "Yes") <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[Jonmo1]

And what results are you expecting (and why) based on that sample data?

 

[ldavis1227]

If A2,B2,C2 are all at or under 14 days(D2), the hope is the answer in E2 be "No"(E2)

 

[Jonmo1]

Perhaps this needs to be clarified..

> means GREATER than
< means LESS than

 

[ldavis1227]

sorry yes, I keep changing them and then switching the yes and no around based on the question I want in E1. Either way, I shouldn't be getting the same results from that set of data, right? E2 and E3 should be different answers.

I'm new to this posting. I should have posted differently from the beginning. I'm learning...