"jingleb@comcast.net" wrote...
>Hello, Can anyone help me with an excel variance formula?
>What I have is a $ amount in one column, and a $ amount
>in the second column. What I want in the third column is
>the variance -- how much change there was from the first
>amount to the second. When I use =var(RANGE) I get all
>positives, but don't get the negatives. I need plus or
>minus in my third column. Maybe variance is not what I am
>looking for, as I am new at this. Thanks for your help. -
You've already received the proper response - just subtract one number from
the other. I'm just writing to point out that the term 'variance' is used in
both statistics and common U.S. business jargon as a synonym for difference.
Excel (and most other general calculation software) only use 'variance' in
the statistical sense, in which only positive values would ever be returned.
You'll save a lot of time if you check online help first for questions like
this. A brief perusal of the entry for the VAR function would have made it
very clear it wasn't what you wanted.
--
To top-post is human, to bottom-post and snip is sublime.
Office