I have a list of values in column A, or any other column if you have the time. but just column A would suffice.
I would like to compare value A1 to value A2 to see if the two values are within a certain range of each other. For example, if If I set the "within" range to be at 20:
if the value of column A1 is 20 and A2 is 19 or 22, output yes in Column B because the value is within a range of 20, if not then output no.
and so forth all the way down the column. What would be the best formula to get this done?
Comparing from the cell before it.
so comparing a1 to a2, a2 to a3 and so on..
I would like to compare value A1 to value A2 to see if the two values are within a certain range of each other. For example, if If I set the "within" range to be at 20:
if the value of column A1 is 20 and A2 is 19 or 22, output yes in Column B because the value is within a range of 20, if not then output no.
and so forth all the way down the column. What would be the best formula to get this done?
Comparing from the cell before it.
so comparing a1 to a2, a2 to a3 and so on..
Code:
[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl63, width: 64"]82 No[/TD]
[/TR]
[TR]
[TD="class: xl63"]26 Yes[/TD]
[/TR]
[TR]
[TD="class: xl63"]24[/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[/TR]
</tbody>[/TABLE]
Last edited: