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]

It worked!!! Thank you! Thank you! We will end up with 100's of lines of data and now we don't have to do it all manually!!!!! You are a life saver!

 

[Jonmo1]

Glad to help, thanks for the feedback.

 

[ldavis1227]

One more quick question. Can you tell me how to lock cells so no one changes any of this data?

 

[Jonmo1]

Use Sheet Protection.

Right click on the sheet's Tab, Protect Sheet
And you can use Format - Cells - Protection to choose which cells should be locked or unlocked.

 

[ldavis1227]

It worked. Thanks again for all your help!