Discussion Excel Formula Problem in Excel
https://techcommunity.microsoft.com/t5/excel/excel-formula-problem/m-p/2731337#M113152
<P>Hi there,</P><P> </P><P>Since the latest update my excel formula =Right(P2,LEN(P2)-16) and also formula =M2+60 isn't working can you please advise on what I am doing wrong. They worked fine on an older version of excel but now the brackets (P2) are highlighted red and aren't being accepted by excel since the update. You assistance is appreciated. </P><P> </P><P>Regards,</P><P>Kimberly </P><DIV><DIV class="sharer-container fade-anim full-height"><DIV class="sharing-controls"><DIV class="sharer-text-channel-fill"><DIV class="user-text-channel-dialog"><DIV class="copy-section"><DIV class="user-text-channel-received-text"> </DIV></DIV></DIV></DIV></DIV></DIV></DIV>Wed, 08 Sep 2021 06:09:43 GMTAllnorth2021-09-08T06:09:43ZExcel Formula Problem
https://techcommunity.microsoft.com/t5/excel/excel-formula-problem/m-p/2731337#M113152
<P>Hi there,</P><P> </P><P>Since the latest update my excel formula =Right(P2,LEN(P2)-16) and also formula =M2+60 isn't working can you please advise on what I am doing wrong. They worked fine on an older version of excel but now the brackets (P2) are highlighted red and aren't being accepted by excel since the update. You assistance is appreciated. </P><P> </P><P>Regards,</P><P>Kimberly </P><DIV><DIV class="sharer-container fade-anim full-height"><DIV class="sharing-controls"><DIV class="sharer-text-channel-fill"><DIV class="user-text-channel-dialog"><DIV class="copy-section"><DIV class="user-text-channel-received-text"> </DIV></DIV></DIV></DIV></DIV></DIV></DIV>Wed, 08 Sep 2021 06:09:43 GMThttps://techcommunity.microsoft.com/t5/excel/excel-formula-problem/m-p/2731337#M113152Allnorth2021-09-08T06:09:43ZRe: Excel Formula Problem
https://techcommunity.microsoft.com/t5/excel/excel-formula-problem/m-p/2731444#M113157
<P><LI-USER uid="1149567"></LI-USER> In principle, there's nothing wrong with either of the formulae. That is, as long as P2 contains something with at least 16 charters/digits and as long M2 does NOT contain a text. You would get #VALUE! errors in both cases.</P><P> </P><P>What do <U>you</U> see when you enter the formulae? If not an error, perhaps you just see the formula as a text. Did you accidentally press "Show formulas" on the Formulas ribbon?</P><P> </P>Wed, 08 Sep 2021 06:47:39 GMThttps://techcommunity.microsoft.com/t5/excel/excel-formula-problem/m-p/2731444#M113157Riny_van_Eekelen2021-09-08T06:47:39ZRe: Excel Formula Problem
https://techcommunity.microsoft.com/t5/excel/excel-formula-problem/m-p/2732031#M113178
<P><LI-USER uid="1149567"></LI-USER> </P><P>Consider verify the calculation options.</P><P>If its manual, your formula will not update automatically.</P><P> </P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Formulas-Calculation-Options-in-Ribbon" style="width: 898px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/308936i38F83F8E23CD7530/image-size/large?v=v2&px=999" role="button" title="Formulas-Calculation-Options-in-Ribbon" alt="Formulas-Calculation-Options-in-Ribbon" /></span></P>Wed, 08 Sep 2021 11:25:18 GMThttps://techcommunity.microsoft.com/t5/excel/excel-formula-problem/m-p/2732031#M113178Juliano-Petrukio2021-09-08T11:25:18Z