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?

[duane]

something like this - tests for the 2 lowest values being <2

change the result of 1 or 0 to whatever you need

=IF(AND(SMALL($H$3:$H$9,1)<2,SMALL($H$3:$H$9,2)<2),1,0)

[pytelium]

Thanks,Duane,will try 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