help needed

  • Thread starter Thread starter pytelium
  • Start date Start date
P

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?
 
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.
 
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
 
Back
Top