Forum Discussion
Solved
Standard Deviation and Formula Look Up
Hello. I am having an Issue with my standard deviation not adjusting based off the date when looking up values. So the formula will not find the date in the table and update the averages based off th...
See the attached version.
The formula in C8 should be
=STDEV.S(IF(C2=POWER[Date],POWER[Weight],))
i.e. with [Date] instead of [@Date]. And it should be confirmed with Ctrl+Shift+Enter to turn it into an array formula.
So I made it an array formula and now I am getting standard deviation values at 117 for the 2/16 when it should be 38. But I am also now getting values for 2/17 so that better.
I added that [@Date] to see if would change anything. It did not. HansVogelaar