Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 3rd 10, 11:25 PM posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 615
Default Variance between two cells only if...

I would like to calculate the variance between A and B, but only if B is
double the number in A.

Example: the value in A1 is 500
the value in B1 is 1000
the variance I would like to show in C1 is 500

however:
if A1 was 500
and B1 is 750
then C1 would be "blank"

Thanks for the help. I appreciate the time.

Jim

  #2   Report Post  
Old February 3rd 10, 11:31 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,942
Default Variance between two cells only if...

=if(B1*2 < A1, "", A1-B1)
--
HTH...

Jim Thomlinson


"Jim" wrote:

I would like to calculate the variance between A and B, but only if B is
double the number in A.

Example: the value in A1 is 500
the value in B1 is 1000
the variance I would like to show in C1 is 500

however:
if A1 was 500
and B1 is 750
then C1 would be "blank"

Thanks for the help. I appreciate the time.

Jim

  #3   Report Post  
Old February 3rd 10, 11:38 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 905
Default Variance between two cells only if...

"Jim" wrote:
I would like to calculate the variance between A
and B, but only if B is double the number in A.


If this is related to your thread "Variance calculations", refer to answers
there, and please avoid submitting redundant postings. The bifurcation leads
to confusion and unnecessary duplication of effort.

But to answer this question:

=if(B1=2*A1, B1-A1, "")

PS: I suggest that you acquire a basic understanding of Excel fundamentals.
This question and your last one related to MAX are rudimentary. We cannot
possibly answer all of your questions as you learn Excel step by step,
especially if you demonstrate disdain for self-learning. One source of the
basics might be "Excel for Dummies".


----- original message -----

"Jim" wrote:
I would like to calculate the variance between A and B, but only if B is
double the number in A.

Example: the value in A1 is 500
the value in B1 is 1000
the variance I would like to show in C1 is 500

however:
if A1 was 500
and B1 is 750
then C1 would be "blank"

Thanks for the help. I appreciate the time.

Jim

  #4   Report Post  
Old February 4th 10, 12:35 PM posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 615
Default Variance between two cells only if...

Joe User,

Your answer did not yield the correct result, thanks for the attempt. Also,
I find your tone condescending. If you feel my questions “elementary” I
would encourage you “not” to respond to my questions in the future. This is
board is a help board not a forum for those that feel they have a better
grasp of Excel to demean others that do not.

Jim
****************

"Joe User" wrote:

"Jim" wrote:
I would like to calculate the variance between A
and B, but only if B is double the number in A.


If this is related to your thread "Variance calculations", refer to answers
there, and please avoid submitting redundant postings. The bifurcation leads
to confusion and unnecessary duplication of effort.

But to answer this question:

=if(B1=2*A1, B1-A1, "")

PS: I suggest that you acquire a basic understanding of Excel fundamentals.
This question and your last one related to MAX are rudimentary. We cannot
possibly answer all of your questions as you learn Excel step by step,
especially if you demonstrate disdain for self-learning. One source of the
basics might be "Excel for Dummies".


----- original message -----

"Jim" wrote:
I would like to calculate the variance between A and B, but only if B is
double the number in A.

Example: the value in A1 is 500
the value in B1 is 1000
the variance I would like to show in C1 is 500

however:
if A1 was 500
and B1 is 750
then C1 would be "blank"

Thanks for the help. I appreciate the time.

Jim

  #5   Report Post  
Old February 4th 10, 01:01 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default Variance between two cells only if...

You'll probably find that "our answer did not yield the correct result" is
not sufficiently specific to get help. If you want further help you'll need
to explain what values you had, what formula you used, what result you got,
and what result you wanted (and why). Sadly, most of us here are not
clairvoyant.

And as for Joe's response, if you don't want to read the basic books or to
use Excel help, you might be more suited to
news:microsoft.public.excel.newusers than to
news:microsoft.public.excel.misc .
And it would be wise to read some advice on how to get the best value out of
newsgroups.
--
David Biddulph


"Jim" wrote in message
...
Joe User,

Your answer did not yield the correct result, thanks for the attempt.
Also,
I find your tone condescending. If you feel my questions "elementary" I
would encourage you "not" to respond to my questions in the future. This
is
board is a help board not a forum for those that feel they have a better
grasp of Excel to demean others that do not.

Jim
****************

"Joe User" wrote:

"Jim" wrote:
I would like to calculate the variance between A
and B, but only if B is double the number in A.


If this is related to your thread "Variance calculations", refer to
answers
there, and please avoid submitting redundant postings. The bifurcation
leads
to confusion and unnecessary duplication of effort.

But to answer this question:

=if(B1=2*A1, B1-A1, "")

PS: I suggest that you acquire a basic understanding of Excel
fundamentals.
This question and your last one related to MAX are rudimentary. We
cannot
possibly answer all of your questions as you learn Excel step by step,
especially if you demonstrate disdain for self-learning. One source of
the
basics might be "Excel for Dummies".


----- original message -----

"Jim" wrote:
I would like to calculate the variance between A and B, but only if B
is
double the number in A.

Example: the value in A1 is 500
the value in B1 is 1000
the variance I would like to show in C1 is 500

however:
if A1 was 500
and B1 is 750
then C1 would be "blank"

Thanks for the help. I appreciate the time.

Jim





  #6   Report Post  
Old February 4th 10, 06:07 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 905
Default Variance between two cells only if...

"Jim" wrote:
This is board is a help board not a forum for those that feel
they have a better grasp of Excel to demean others that do not.


I am sorry if my comments offended you. I probably did not express myself
very well.

We -- and I, in particular -- help people all the time who ask elementary
questions. I see nothing wrong with that. And I do not feel it is
necessary to post such questions to m.p.e.newusers. These NGs have lost
their original distinctive purposes long ago.

But you asked a number of questions in just 2 hours, the two most recent
being very elementary. What I was trying to say is: I think it is an
inefficient use of your time to post such simple questions step-by-step as
apparently you are developing a worksheet to solve some problem(s). I think
it would be better for you if you learned the fundamentals from a book.

Generally, the "for Dummies" series of books tends to be very good
introductions to subjects. The quality is not uniform; and some of those
books "dumb down" the subject matter too much. But they do tend to avoid
esoteric features that can clutter the fundamentals, a flaw of many other
so-called introductory books. I am sorry that the title says "for Dummies".
I'm sure that puts off a lot of people, and it certainly can be
misinterpreted when we suggest it.

There was nothing intentionally condescending in my tone. I was simply
making a factual observation and offering a suggestion that I felt would be
the most efficient way for you learn the fundamentals.


----- original message -----

"Jim" wrote in message
...
Joe User,

Your answer did not yield the correct result, thanks for the attempt.
Also,
I find your tone condescending. If you feel my questions “elementary” I
would encourage you “not” to respond to my questions in the future. This
is
board is a help board not a forum for those that feel they have a better
grasp of Excel to demean others that do not.

Jim
****************

"Joe User" wrote:

"Jim" wrote:
I would like to calculate the variance between A
and B, but only if B is double the number in A.


If this is related to your thread "Variance calculations", refer to
answers
there, and please avoid submitting redundant postings. The bifurcation
leads
to confusion and unnecessary duplication of effort.

But to answer this question:

=if(B1=2*A1, B1-A1, "")

PS: I suggest that you acquire a basic understanding of Excel
fundamentals.
This question and your last one related to MAX are rudimentary. We
cannot
possibly answer all of your questions as you learn Excel step by step,
especially if you demonstrate disdain for self-learning. One source of
the
basics might be "Excel for Dummies".


----- original message -----

"Jim" wrote:
I would like to calculate the variance between A and B, but only if B
is
double the number in A.

Example: the value in A1 is 500
the value in B1 is 1000
the variance I would like to show in C1 is 500

however:
if A1 was 500
and B1 is 750
then C1 would be "blank"

Thanks for the help. I appreciate the time.

Jim




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
% Variance Abdul[_2_] Excel Worksheet Functions 3 November 9th 09 06:25 AM
Variance FreddieP Excel Discussion (Misc queries) 5 September 28th 06 01:41 PM
variance % karibug Excel Worksheet Functions 5 June 14th 06 10:54 PM
Pivot Tables - Variance and Variance % PJS Excel Discussion (Misc queries) 2 January 18th 06 03:12 AM
Pivot Tables - Variance and % Variance fields CraigS Excel Discussion (Misc queries) 5 January 6th 05 12:22 AM


All times are GMT +1. The time now is 06:19 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017