Forum Discussion
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
- An alternative would be =ABS(A1-A2) which gives the absolute difference as a positive number.
- Thank you - this worked well too!
this worked well too!
One of the neat things about Excel: there are always multiple ways to get from A to B.
HansVogelaar thank you! this works
