Make negative a positive

[billy2willy]

Lets say I have a spreadsheet with
Column A
Column B
Column C = Difference between B and A

I would do b - a or a - b but I want all my answers to be positive.

How do I do this?

[VBA Noob]

Hi,

Put this in C1 and drag down

=ABS(A1-B1)

VBA Noob