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

Copper Contributor

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