N/A error using PROGNOSE.LINEAR() with INDIRECT()

%3CLINGO-SUB%20id%3D%22lingo-sub-1823410%22%20slang%3D%22en-US%22%3EN%2FA%20error%20using%20PROGNOSE.LINEAR()%20with%20INDIRECT()%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1823410%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everybody.%20I%20am%20trying%20to%20use%26nbsp%3BPROGNOSE.LINEAR()%20with%20INDIRECT()%20together%20but%20i%20am%20getting%20NA%20error.%20I%20am%20trying%20to%20check%20with%20direct%20link%2C%20just%20for%20example%20%24A%244%20-%20it%20goes%20fine.%20IDIRECT%20makes%20the%20exact%20same%20%24A%244%20link%20but%20fails%20with%20NA.%20I%20am%20computing%20formula%20step%20by%20step%20-%20no%20error%20and%20the%20same%20result%20until%20final%20PROGNOSE%20computation.%20So%20for%20example%20my%20PROGNOSE%20formula%20in%20Calculation%20window%20is%20the%20same%20-%20PROGNOSE.LINEAR(40%3B%20%7B1%2C95%3A1%2C7%7D%3B%7B40%3A60%7D%20but%20the%20direct%20%24A%244%20link%20gives%20me%20expected%201%2C95%20and%20INDIRECT(%22%24A%244%22)%20fails%20with%20%23NA%3C%2FP%3E%3CP%3EWhat%20am%20I%20doing%20wrong%3F%20Please%20help%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1823410%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi everybody. I am trying to use PROGNOSE.LINEAR() with INDIRECT() together but i am getting NA error. I am trying to check with direct link, just for example $A$4 - it goes fine. IDIRECT makes the exact same $A$4 link but fails with NA. I am computing formula step by step - no error and the same result until final PROGNOSE computation. So for example my PROGNOSE formula in Calculation window is the same - PROGNOSE.LINEAR(40; {1,95:1,7};{40:60} but the direct $A$4 link gives me expected 1,95 and INDIRECT("$A$4") fails with #NA

What am I doing wrong? Please help me.

0 Replies