moncover formula

Copper Contributor

Hello,

I want to calculate forward coverage with @moncover formula. It works in one excel document on my computer. But it does not work a new excel document I wanted to create. Could you please help me why?

 

If there is any other calculation or formula, please help me. 

 

I have stocks on one row, and forecasts on the other row (columns in weeks). I want to write a formula to calculate for each column that the related stock will cover how many weeks/months.moncover, Formulas and Functions

 

Thanks.

0 Replies