Forum Discussion

Colt45's avatar
Colt45
Copper Contributor
Apr 30, 2019
Solved

Help breaking down formula

Hi, I am new to the community and somewhat new to the formula side of excel. Working on an excel sheet created by someone else. I would like help breaking down this formula. What do the individual p...
Formulas and Functions
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Apr 30, 2019

    Also Sheet1 is a defined Name

    If you go to the Formulas menu and click Defined Name you'll see where that Sheet1 is referring to

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Apr 30, 2019

Also Sheet1 is a defined Name

If you go to the Formulas menu and click Defined Name you'll see where that Sheet1 is referring to

Colt45's avatar
Colt45
Copper Contributor
May 07, 2019

Wyn Hopkins

 

Thanks a lot, the names manager helped clear the problem.

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    May 07, 2019
    Glad it helped

Resources