Forum Discussion

CV2023's avatar
CV2023
Copper Contributor
Jul 03, 2023

Formula Miscalculation

https://1drv.ms/x/s!Askv3RjJkg9lhkmphKeJesnxPwsg?e=dnUFj5&nav=MTVfe0FFNDQ1OThGLTVBQzAtNDNFNi04MDQ1LUIzRTM2MERFQ0ZEQ30 https://1drv.ms/x/s!Askv3RjJkg9lhksH-PJCTu28QzXM?e=LfhF50&nav=MTVfezY3OTc5MjE3LUN...
excel
Formulas and Functions
CV2023's avatar
CV2023
Copper Contributor
Jul 07, 2023
Ok I have posted the samples
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jul 07, 2023

CV2023 Have a look at the attached file where I completely changed the formula in the Blank sheet. The existing one was a monster. See if the revised template works better.

  • CV2023's avatar
    CV2023
    Copper Contributor
    Jul 07, 2023
    Maybe I am doing something wrong or the file is corrupted. I can see the sample but when I try to input(copy&paste) into an active sheet or even the samples I have it says there is a problem with the formula
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jul 07, 2023

      CV2023 

      To change the table name stay on any cell within the table and on ribbon in Table Design tab change the name in Table Name box

Resources