Thread: Formula for positive values?

How do I get a formula to always return a positive value?
Lets say cell A1=5 and A2=10. I tried the imsub(a1,a2), but it is returning a -5. I would like to just return the difference (ie. 5).

Thanks

try

=ABS(A1-A2)

edvwvw

thanks...that does work, but i am still having issues. Here is what i am reall trying to accomplish.
Lets say i have these three cells: a1=10, a2=9, and a3=2. I want cell a4 to return the max difference (as a positive #) between cells a1-a3 (ie. in my example a4=8).

Any suggestions? Thanks

=ABS(MAX(A1-A3,A2-A3))

edvwvw

great..thanks!!!!!