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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

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


"countingfish" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Hi all,
> ok am obviously being incredibly thick, and therefore cant work out
> 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 the
> difference (always as a positive number) I cant just minus one from the
> other as which number is biggest varies accross the sheet, at the
> moment i am taking them away, squaring it and then square rooting it,
> there must be a better way!!!!
>
> cheers
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>