View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
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