When using auto sum change negative numbers to positive

Question

Hello,&nbsp;I'm using =a1-a2 in excel to find difference between product expected and product arrived, but when I get more product arriving than what I expected the formula gives me a negative total.&nbsp;How can I change that negative total to a positive and show a plus sign in front of the number.&nbsp;Example:Expected14Arrived&nbsp;17Total-3

hansvogelaar · Answer

AEHino1765&nbsp;
Use
&nbsp;
=A2-A1
&nbsp;
and apply the custom number format +0;-0;0 to the cell with the formula

mathetes · Answer

An alternative would be =ABS(A1-A2) which gives the absolute difference as a positive number.

aehino1765 · Answer

HansVogelaar&nbsp;thank you! this works

aehino1765 · Answer

Thank you - this worked well too!

mathetes · Answer

AEHino1765&nbsp;this worked well too!&nbsp;One of the neat things about Excel: there are always multiple ways to get from A to B.&nbsp;

Forum Discussion

When using auto sum change negative numbers to positive

5 Replies

Resources

Expected	14
Arrived	17
Total	-3