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
|