I have searched and searched all day for this answer and cannot find it.
I simply want the following:
Column A Column B = Column C
-$5 $6 = $1
$8 $2 = $6
-$2 $5 = $3
$5 -$5 = $0
See my pattern? ABS won't work because for example you end up with 11 on the first one. I don't want percent difference either. A1-B1=C1 won't work because sometimes A is positive and sometimes B is positive. Nor the reverse of A1+B1=C1 it will work only when the order of numbers is correct. I am trying to avoid doing each row individually.
This seems so simple, but is killing me. Basically column A is estimated and column B is actual and I want to see the difference on these projects.
Thank you Thank you Thank you for any help! Again I have searched and searched and either don't know the correct terms or it is so simple people haven't asked it or...??? I see close topics, but nothing quite like this.
I searched "sum negative positive", "find difference", etc...
I hope I am not wasting anyone's time, but I really can't figure this out.
I simply want the following:
Column A Column B = Column C
-$5 $6 = $1
$8 $2 = $6
-$2 $5 = $3
$5 -$5 = $0
See my pattern? ABS won't work because for example you end up with 11 on the first one. I don't want percent difference either. A1-B1=C1 won't work because sometimes A is positive and sometimes B is positive. Nor the reverse of A1+B1=C1 it will work only when the order of numbers is correct. I am trying to avoid doing each row individually.
This seems so simple, but is killing me. Basically column A is estimated and column B is actual and I want to see the difference on these projects.
Thank you Thank you Thank you for any help! Again I have searched and searched and either don't know the correct terms or it is so simple people haven't asked it or...??? I see close topics, but nothing quite like this.
I searched "sum negative positive", "find difference", etc...
I hope I am not wasting anyone's time, but I really can't figure this out.
Last edited: