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. ...
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.