View Single Post
  #1   Report Post  
pm
 
Posts: n/a
Default differences in groups of numbers

Hello there-

I have a column of 10 numbers. The last row of the column is a control
value. I would like to know the easiest way to see if any of the previous 9
numbers in a column divided by the control number is .6 or less. I tried OR
function and it works, but I will be dealing with bigger columns of up to 100
numbers to compare to a control number and the OR function in this case would
be cumbersome.

PM