Difference on number line between two numbers and indicating more "positive" or "negative"

[alienmembr]

[TABLE="width: 672"]
<TBODY>[TR]
[TD="colspan: 3"]I have hundreds of data points, I manually go through each week from testing and type it in correctly. It may be an easy fix but I have gone way too deep in the rabbit hole on this one. I have totally confused myself. It looked easy at first.

Is B6 more negative than A6 and by how much?</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]Is B6 more positive than A6 and by how much?</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"]Position on number line and comparing number both being negative numbers.</SPAN>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fixed number</SPAN>[/TD]
[TD]Comparing number.</SPAN>[/TD]
[TD]Difference from position on number line. (My attempt was just to subtract)</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] A</SPAN>[/TD]
[TD] B</SPAN>[/TD]
[TD] Result</SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]-0.2</SPAN>[/TD]
[TD="align: right"]-0.4</SPAN>[/TD]
[TD="align: right"]0.2</SPAN>[/TD]
[TD] Math correct but not what I am looking to do.</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]-0.2</SPAN>[/TD]
[TD="align: right"]-0.4</SPAN>[/TD]
[TD="align: right"]-0.2</SPAN>[/TD]
[TD] Correct. Not in math but in my needs. </SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]0.2</SPAN>[/TD]
[TD="align: right"]-0.4</SPAN>[/TD]
[TD="align: right"]0.6</SPAN>[/TD]
[TD] Math correct but not what I am looking to do. </SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]0.2</SPAN>[/TD]
[TD="align: right"]-0.4</SPAN>[/TD]
[TD="align: right"]-0.6</SPAN>[/TD]
[TD] Correct. Number is .6 more negative</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]0.2</SPAN>[/TD]
[TD="align: right"]0.2</SPAN>[/TD]
[TD="align: right"]0</SPAN>[/TD]
[TD] Correct. Numbers are the same. No difference.</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]0.4</SPAN>[/TD]
[TD="align: right"]0.2</SPAN>[/TD]
[TD="align: right"]0.2</SPAN>[/TD]
[TD] Math correct but not what I am looking to do. </SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]0.4</SPAN>[/TD]
[TD="align: right"]0.2</SPAN>[/TD]
[TD="align: right"] -0.2 </SPAN>[/TD]
[TD] Correct. Number is .2 more negative.</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]0.2</SPAN>[/TD]
[TD="align: right"]0.4</SPAN>[/TD]
[TD="align: right"]-0.2</SPAN>[/TD]
[TD] Math correct but not what I am looking to do. </SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]0.2</SPAN>[/TD]
[TD="align: right"]0.4</SPAN>[/TD]
[TD="align: right"]0.2</SPAN>[/TD]
[TD] Correct. Number is .2 more positive.</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL></COLGROUP>[/TABLE]

 

[bbott]

Hi,

Wouldn't B6 - A6 give you your desired result for each of these?

 

[alienmembr]

Hi,

Wouldn't B6 - A6 give you your desired result for each of these?

Yes. It would. As stated it started simply enough. A simple subtraction, turned into a string of If statements combined with AND's then resulted in me thinking I have to be looking at this wrong. Again K.I.S.S. got the best of me.