comparingnumbers

[countingfish]

Hi all,
ok am obviously being incredibly thick, and therefore cant work ou
how to do this but if anyone can help that would be great.

All i want to be able to do is compare 2 numbers in excel and get th
difference (always as a positive number) I cant just minus one from th
other as which number is biggest varies accross the sheet, at th
moment i am taking them away, squaring it and then square rooting it
there must be a better way!!!!

cheer

 

[David]

Use the ABS() function which will give you the absolute value (magnitude).

E.g. =ABS(A1-A2) will give you 10 (not -10) if A1 is 15 and A2 is 25.

David