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
|