I have received a file that I am trying to understand the flow of the
formulas...I follow everything until I get to the formula below:

{=TABLE(A1,)}

When I click on "Evaluate Formula" and go through the steps I see:

=sum(Data!AX5:AX8201)*(1+Assumptions!$C$21)

The sum in the AX column in Data sheet always sums to 1,091,229 and cell C21
on Assumptions sheet is 0.20. So for all places that I see this formula, I
should get 1,309,476. However, there is a different value in the cells that
have the above mentioned formula.

My question: How do I determine what other cells are having and effect on
the outcome of the formula?

A little more background:
1) Data sheet column AX represents future year inventory of 8,000 or so
SKUs
2) The formula {=TABLE(A1,)} is on the Results sheet in range C3:Z8 where
columns represent fiscal quarters and the rows are stores.
3) I am trying to figure out quarterly inventory by store

Thanks in advance,

Steve

This refers to a data table, used to forecast values with what-if
analyses. Put "table" in XL Help Index (keyword) to find out more.
I've never used them, so I can't advise further.

Hope this helps.

Pete

On Oct 25, 6:17 pm, "CrazyEd" wrote:
I have received a file that I am trying to understand the flow of the
formulas...I follow everything until I get to the formula below:

{=TABLE(A1,)}

When I click on "Evaluate Formula" and go through the steps I see:

=sum(Data!AX5:AX8201)*(1+Assumptions!$C$21)

The sum in the AX column in Data sheet always sums to 1,091,229 and cell C21
on Assumptions sheet is 0.20. So for all places that I see this formula, I
should get 1,309,476. However, there is a different value in the cells that
have the above mentioned formula.

My question: How do I determine what other cells are having and effect on
the outcome of the formula?

A little more background:
1) Data sheet column AX represents future year inventory of 8,000 or so
SKUs
2) The formula {=TABLE(A1,)} is on the Results sheet in range C3:Z8 where
columns represent fiscal quarters and the rows are stores.
3) I am trying to figure out quarterly inventory by store

Thanks in advance,

Steve