Forum Discussion
data table problem
Hi all! why the results of data table are wrong when I use an equation in input column and they are correct when I use numbers as shown in the example of summation below
3 Replies
The formulas in C18:C24 refer D3, and D3 also influences the result of D10:H10 and hence the result of =SUM(D11:H11). This causes a conflict.
Either replace the formulas in C18:C24 with their values, or change the formulas so that they don't relate directly or indirectly to cells that affect the outcome of =SUM(D11:H11)
Ali_Nadhum You sheet has formulae like:
={TABLE(,D3)}
TABLE is not an Excel function as far as I know. What is this supposed to do?
Hi Riny, see Data Tables
