Forum Discussion

Turren99's avatar
Turren99
Copper Contributor
Oct 21, 2023

Excel...simple formula not working

I have the Family Office 365 version, so not the Primary holder yet expect Excel to work. I create a number in cell e51; ans 5  I create a number in f51; ans 10.  Both from either Find or Len functi...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 21, 2023

Turren99 

Please check if you are in Automatic mode

  • Turren99's avatar
    Turren99
    Copper Contributor
    Oct 21, 2023
    Did check that...and Yes it is
    • Turren99's avatar
      Turren99
      Copper Contributor
      Oct 21, 2023
      https://1drv.ms/x/s!ApvNP5zxc9GNgijrXnYeBD_l5UQz?e=8Xhe0W
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Oct 21, 2023

        Turren99 

        Thanks! Your formula in G52 refer to cells in row 51, but the cells you want are in row 52:

        Since E51 and F51 are blank, your formula =IF(E51=0,0,RIGHT(B51,(F51-E51))) returns 0.

        If you refer to E52 and F52, you get the desired result:

Resources