moncover formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3365307%22%20slang%3D%22en-US%22%3Emoncover%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3365307%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20want%20to%20calculate%20forward%20coverage%20with%20%40moncover%20formula.%20It%20works%20in%20one%20excel%20document%20on%20my%20computer.%20But%20it%20does%20not%20work%20a%20new%20excel%20document%20I%20wanted%20to%20create.%20Could%20you%20please%20help%20me%20why%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20there%20is%20any%20other%20calculation%20or%20formula%2C%20please%20help%20me.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20stocks%20on%20one%20row%2C%20and%20forecasts%20on%20the%20other%20row%20(columns%20in%20weeks).%20I%20want%20to%20write%20a%20formula%20to%20calculate%20for%20each%20column%20that%20the%20related%20stock%20will%20cover%20how%20many%20weeks%2Fmonths.moncover%2C%20Formulas%20and%20Functions%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3365307%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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