How to calculate delta value of current cell - previous 10 day average

0

I would like to calculate the difference between the value of a cell and the average value of previous 10 cells in the same column.

Data is arranged in 3 columns: Date, value, value-mean.

Answer
Discuss

Answers

0

=B11-average(B1:B10)

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login