O'Reilly logo

Hands-On Financial Modeling with Microsoft Excel 2019 by Shmuel Oluwa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Troubleshooting

In the event that there is an error, there are certain steps you can take to quickly eliminate several possibilities:

  • Precedents: Precedents are those cells that have been referred to in arriving at the value in a particular cell
  • Dependents: Dependents are those cells that have included the cell in focus in their formula

The following screenshot will be used to explain this further:

From the preceding screenshot, let's look at cell K8. The formula in that cell is =K6*(1-$D$7), so cells K6 and D7 are the precedents of cell K8. On the other hand, cell K8 is a dependent of both cells K6 and D7.

On the Formula ribbon, in the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required