View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
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