A. B2:B11="Sweater" is the first criteria of the formula, meaning: lookup the "Sweater" in B2:B11, if it is "Sweater", return True, otherwise return False. At the time of execution, B2 is taken out from B2:B11 for the first time; since B2 is "Down jacket", it returns to F...
I am trying to calculate the standard deviation of a all the values in a KF using the macro function STDEV(), and I am not getting the right results, when I check with the same caculation done on the values of the same KF in excel, I get a different value. I am using lets say ...