When using auto sum change negative numbers to positive

[AEHino1765]

Hello,

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.

How can I change that negative total to a positive and show a plus sign in front of the number.

Example:

Expected	14
Arrived	17
Total	-3

[#2]

@AEHino1765 

Use

=A2-A1

and apply the custom number format +0;-0;0 to the cell with the formula

[#3]

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

[#4]

@HansVogelaar thank you! this works

[#5]

Thank you - this worked well too!

[#6]

@AEHino1765 

this worked well too!

One of the neat things about Excel: there are always multiple ways to get from A to B.