positive

[drchit]

how do i keep the difference between two numbers always positive?
e.g
24-36= -12 (how do i change -12 to +12?)

 

[rikrak]

On 2002-08-29 05:24, drchit wrote:
how do i keep the difference between two numbers always positive?
e.g
24-36= -12 (how do i change -12 to +12?)

abs(-12)=12

 

[Aladin Akyurek]

Put otherwise, wrap ABS around of your difference formula... e.g.,

=ABS(A1-B1)