Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
% Variance | Excel Worksheet Functions | |||
Variance | Excel Discussion (Misc queries) | |||
variance % | Excel Worksheet Functions | |||
Pivot Tables - Variance and Variance % | Excel Discussion (Misc queries) | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) |