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

alienmembr

New Member
Joined
Jul 29, 2012
Messages
5
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>
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

bbott

Well-known Member
Joined
Feb 5, 2010
Messages
2,350
Hi,

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

alienmembr

New Member
Joined
Jul 29, 2012
Messages
5
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,892
Messages
5,598,702
Members
414,254
Latest member
MarieCo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top