select cell d19
<tools<formula auditing<trace dependents
a blue arrow show show from D19 to the cell with the formula used in the table
your table should start right and down one cell
the values in the table will change by sustituting the values to the right
of the arrow into the equation at the arrow in the place of what the eqyation
shows as D20 and D19 will be replaced by the values below the equation.


This is from interpreting items in Help. with which I sometimes (ok most of
the time) have problems.


" wrote:

I can't figure out where the formula is that the table refers to.
That's the problem. It's like the formula is hidden.

On Jun 1, 7:47 am, "Roger Govier"
wrote:
see reply to earlier message

--
Regards

Roger Govier

wrote in message

oups.com...

I'm reviewing someone else's excel model and I've run across something
I hadn't seen before. This is a repeated function in what appears to
be a 5x5 table. Obviously, D19 and D21 are referring to specific
cells. When I change those reference cells, the table changes.
However, I can't figure out where the results within this table are
coming from? For finance types, the results within the table are
IRRs, and the table is a sensitivity analysis (based on the D19 and
D21 reference cells) but I can't see where it's drawing from.

Any help would be appreciated.

Thanks.