Forum Discussion
Solved
Calculate difference, pos or neg between numbers
I'm new to Excel and having a problem figuring this out. Here's a simplified explanation of what I'm trying to do: In A2 I have 100 In A3 I have 150, an increase of 50 In B3 I want to show the inc...
I you want an increase to be positive and a decrease to be negative, use =A3-A2
If you always want a positive (or zero) result, use =ABS(A3-A2)
If you'd like to learn about formulas and functions, see for example Formulas and Functions and the links provided there.
Thanks