View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
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