# When using auto sum change negative numbers to positive

Copper Contributor

# When using auto sum change negative numbers to positive

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
5 Replies

# Re: When using auto sum change negative numbers to positive

Use

=A2-A1

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

# Re: When using auto sum change negative numbers to positive

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

# Re: When using auto sum change negative numbers to positive

@HansVogelaar thank you! this works

# Re: When using auto sum change negative numbers to positive

Thank you - this worked well too!

# Re: When using auto sum change negative numbers to positive

this worked well too!

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