Hello
This is what i am trying to achieve:
In column: AU I have the net total of various numbers. Sometimes the net number is positive other times negative.
I want to know the difference between Column AT and AS.....
So this is what I have tried:
=AS-AT
Problem with this: if AT is a negative number and AS is positive it adds to make a negative... Not what im looking for, the answer should be: -8.70.
AS AT AU (net)
<colgroup><col width="64" span="2" style="width:48pt"><col width="64" style="width:48pt"></colgroup><tbody>
</tbody>
I then try this: =AS2-ABS(AT2)
Problem: This works with AT being negative number and AS being positive... the result is correct at -8.70.
However the problem then goes on IF: AS is negative value and AT positive.... the numbers are added to create -3.26 which is errorsome, the correct value should be 1.14
AS AT AU (Net)
<colgroup><col width="64" span="2" style="width:48pt"><col width="64" style="width:48pt"></colgroup><tbody>
</tbody>
I then try this: =AT2-ABS(AS2)
Problem with this: If AT2 is negative, then it adds the positive to make a deeper negative: -12.66. However, this works when the AS column is a negative value.... the formula is correct and gives correct value of 1.14.
<colgroup><col width="64" span="2" style="width:48pt"> <col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
Has anyone got the answer? Im thinking along the lines of
=if AS is >0 value and AT<0 value then =AS2-ABS(AT2) IF NOT then... =AT2-ABS(AS2)
Thanks for any help
This is what i am trying to achieve:
In column: AU I have the net total of various numbers. Sometimes the net number is positive other times negative.
I want to know the difference between Column AT and AS.....
So this is what I have tried:
=AS-AT
Problem with this: if AT is a negative number and AS is positive it adds to make a negative... Not what im looking for, the answer should be: -8.70.
AS AT AU (net)
<colgroup><col width="64" span="2" style="width:48pt"><col width="64" style="width:48pt"></colgroup><tbody> </tbody> |
<colgroup><col width="64" span="2" style="width:48pt"><col width="64" style="width:48pt"></colgroup><tbody>
</tbody>
I then try this: =AS2-ABS(AT2)
Problem: This works with AT being negative number and AS being positive... the result is correct at -8.70.
However the problem then goes on IF: AS is negative value and AT positive.... the numbers are added to create -3.26 which is errorsome, the correct value should be 1.14
AS AT AU (Net)
1.98 | -10.68 | -8.70 |
-1.06 | 2.20 | -3.26 |
9.53 | -3.07 | 6.46 |
6.07 | 0.18 | 5.89 |
3.90 | 1.21 | 2.69 |
3.79 | -0.35 | 3.44 |
-5.75 | 0.22 | -5.97 |
1.29 | 4.96 | -3.67 |
-9.64 | -7.33 | -16.97 |
11.22 | 4.74 | 6.48 |
-0.04 | 1.86 | -1.90 |
7.02 | -5.71 | 1.31 |
3.47 | 4.06 | -0.59 |
-1.91 | -1.78 | -3.69 |
4.69 | 1.41 | 3.28 |
3.65 | -2.74 | 0.91 |
-0.11 | -3.75 | -3.86 |
6.09 | -1.29 | 4.80 |
-8.28 | -3.91 | -12.19 |
5.57 | 3.00 | 2.57 |
5.29 | 4.47 | 0.82 |
0.88 | 7.12 | -6.24 |
-0.89 | -1.60 | -2.49 |
0.79 | 2.73 | -1.94 |
<colgroup><col width="64" span="2" style="width:48pt"><col width="64" style="width:48pt"></colgroup><tbody>
</tbody>
I then try this: =AT2-ABS(AS2)
Problem with this: If AT2 is negative, then it adds the positive to make a deeper negative: -12.66. However, this works when the AS column is a negative value.... the formula is correct and gives correct value of 1.14.
1st hour | Last Hour | Net |
1.98 | -10.68 | -12.66 |
-1.06 | 2.20 | 1.14 |
9.53 | -3.07 | -12.60 |
6.07 | 0.18 | -5.89 |
3.90 | 1.21 | -2.69 |
3.79 | -0.35 | -4.14 |
-5.75 | 0.22 | -5.53 |
1.29 | 4.96 | 3.67 |
-9.64 | -7.33 | -16.97 |
11.22 | 4.74 | -6.48 |
-0.04 | 1.86 | 1.82 |
7.02 | -5.71 | -12.73 |
3.47 | 4.06 | 0.59 |
-1.91 | -1.78 | -3.69 |
4.69 | 1.41 | -3.28 |
3.65 | -2.74 | -6.39 |
-0.11 | -3.75 | -3.86 |
6.09 | -1.29 | -7.38 |
-8.28 | -3.91 | -12.19 |
5.57 | 3.00 | -2.57 |
5.29 | 4.47 | -0.82 |
0.88 | 7.12 | 6.24 |
-0.89 | -1.60 | -2.49 |
0.79 | 2.73 | 1.94 |
<colgroup><col width="64" span="2" style="width:48pt"> <col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
Has anyone got the answer? Im thinking along the lines of
=if AS is >0 value and AT<0 value then =AS2-ABS(AT2) IF NOT then... =AT2-ABS(AS2)
Thanks for any help