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

[alienmembr]

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>
Is B6 more positive than A6 and by how much?</SPAN>
Position on number line and comparing number both being negative numbers.</SPAN>
Fixed number</SPAN>	Comparing number.</SPAN>	Difference from position on number line. (My attempt was just to subtract)</SPAN>
A</SPAN>	B</SPAN>	Result</SPAN>
-0.2</SPAN>	-0.4</SPAN>	0.2</SPAN>	Math correct but not what I am looking to do.</SPAN>
-0.2</SPAN>	-0.4</SPAN>	-0.2</SPAN>	Correct. Not in math but in my needs. </SPAN>
0.2</SPAN>	-0.4</SPAN>	0.6</SPAN>	Math correct but not what I am looking to do. </SPAN>
0.2</SPAN>	-0.4</SPAN>	-0.6</SPAN>	Correct. Number is .6 more negative</SPAN>
0.2</SPAN>	0.2</SPAN>	0</SPAN>	Correct. Numbers are the same. No difference.</SPAN>
0.4</SPAN>	0.2</SPAN>	0.2</SPAN>	Math correct but not what I am looking to do. </SPAN>
0.4</SPAN>	0.2</SPAN>	-0.2 </SPAN>	Correct. Number is .2 more negative.</SPAN>
0.2</SPAN>	0.4</SPAN>	-0.2</SPAN>	Math correct but not what I am looking to do. </SPAN>
0.2</SPAN>	0.4</SPAN>	0.2</SPAN>	Correct. Number is .2 more positive.</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL></COLGROUP>

 

[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.