Help!

Excel Variance Formula

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users RSS
Next:  Inserting a toggle button in a worksheet cell?  
Author Message
anonymous
External


Since: Jan 05, 2004
Posts: 1



PostPosted: Mon Jan 05, 2004 6:59 pm    Post subject: Excel Variance Formula
Archived from groups: microsoft>public>excel>newusers (more info?)

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. -
JB
Back to top

External


Since: Sep 15, 2003
Posts: 23



PostPosted: Tue Jan 06, 2004 1:54 am    Post subject: Re: Excel Variance Formula [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"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.
Back to top
Trevor Shuttleworth
External


Since: Apr 02, 2004
Posts: 484



PostPosted: Tue Jan 06, 2004 4:19 am    Post subject: Re: Excel Variance Formula [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

JB

don't you just need to subtract the numbers ? Or am I missing something?

3 (in A4) 1 (in B4) =A4-B4 2
2 (in A5) 2 (in B5) =A5-B5 0
1 (in A6) 3 (in B6) =A6-B6 -2


Regards

Trevor

"jingleb@comcast.net" wrote in message

 > 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. -
 > JB
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum