help needed

[pytelium]

I have a number of cell,say h5 to h11. I need to create a function that
carries out an action when any 2 of these cells is less than 1.The
numbers are continuously changing.e.g

h5 4
h6 3
h7 1.5
h8 1.7
h9 10
h10 11
h11 2.4

IF function can work IF(AND(H5<1,H6<1),"Yes","No") but this only
checks one pair,i need to check many pairs.How do I do it?

 

[pytelium]

Thanks,Duane,it works. Now for a harder question,I only want to carry
out the action,if it is the third number to go below two,say h5 cell
has gone below 2 at some stage and h5 has has gone below 2 and now h7
goes below 2,I want to carry out the action now.

 

[duane]

im not sure what you mean - now 3 cells below 2?

 

[pytelium]

the data in my spreadsheet is changing very second.It is feeding from an
external source.If it start monitoring the data for say 2 minutes,I want
to take action if 3 of the 8 cells at any time(not necessarily
simultaneously this time) go below a value of 2.
Thanks