Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
Counting differences in numbers across columns | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) |