Hi,
I can't find a solution to a following issue:
I have a % of something every week, and it is known for 42 weeks.
Week 1 = 90% ; 2 = 95% ; 3 = 92% ; 4 = 98% ; 5 = 100% ; (...) ; 42 = 95%.
And the probability for the remaining 14 weeks is 100% every week.
And I need to know the average for 56 weeks considering previously mentioned.
In formula it could be =average(A1:A42,100% times 14 weeks)
How can I write that "100% for 14 weeks"?
Bookmarks