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