Forum Discussion

imokayithinkso's avatar
imokayithinkso
Copper Contributor
May 29, 2022
Solved

I keep getting double false how to modify formula

formula:

=(MID(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:" & LEN(B2))),1)) ,SEQUENCE(LEN(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:" & LEN(B2))),1)) )),1))=MID(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:" & LEN(B2))),1)),1+LEN(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:" & LEN(B2))),1)))-SEQUENCE(LEN(SUMPRODUCT(--MID(B2,ROW(INDIRECT("1:" & LEN(B2))),1)))),1)

 

This formula states that if a number has a digit sum that is a palindrome the value will be TRUE and if not FALSE

 

I have started using formulas in excel this week and I don't know why the it yields double FALSE and it spills in the next column...Please help me to modify it.

 

Thank you!

 

https://docs.google.com/spreadsheets/d/1QOrfeulmXEyuu5L40XeMV3SFqTVNImMU/edit?usp=sharing&ouid=113026350684576655408&rtpof=true&sd=true 

excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 29, 2022

    imokayithinkso Since you  are using a modern Excel version that allows you to use Dynamic Array functions, try this formula in C2 in stead

     

    =TEXTJOIN(,,MID(B2,SEQUENCE(LEN(B2)),1))=TEXTJOIN(,,MID(B2,SEQUENCE(LEN(B2),,LEN(B2),-1),1))

     

     

     

     

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    May 29, 2022

    imokayithinkso Since you  are using a modern Excel version that allows you to use Dynamic Array functions, try this formula in C2 in stead

     

    =TEXTJOIN(,,MID(B2,SEQUENCE(LEN(B2)),1))=TEXTJOIN(,,MID(B2,SEQUENCE(LEN(B2),,LEN(B2),-1),1))

     

     

     

     

Resources