Hello
I made a data table and it generates DIV errors.
Are there any limitations when using data tables?
How do we specify the formula we want to use?
My formula is:
=MIN($C$8/(C4*INDEX('Part 2'!$C$26:$AS$47,3,MATCH($C$2+'Part 2'!$C$6+1,'Part 2'!$C$26:$AS$26))+C4*(1+INDEX('Part 2'!$C$26:$AS$47,3,MATCH($C$2+'Part 2'!$C$6+1,'Part 2'!$C$26:$AS$26)))*INDEX('Part 2'!$C$26:$AS$47,3,MATCH($C$2+'Part 2'!$C$6+2,'Part 2'!$C$26:$AS$26))+C4*(1+INDEX('Part 2'!$C$26:$AS$47,3,MATCH($C$2+'Part 2'!$C$6+1,'Part 2'!$C$26:$AS$26)))*(1+INDEX('Part 2'!$C$26:$AS$47,3,MATCH($C$2+'Part 2'!$C$6+2,'Part 2'!$C$26:$AS$26)))*INDEX('Part 2'!$C$26:$AS$47,3,MATCH($C$2+'Part 2'!$C$6+3,'Part 2'!$C$26:$AS$26))+INDEX('Part 2'!$C$26:$AS$47,18,MATCH($C$2+'Part 2'!$C$6,'Part 2'!$C$26:$AS$26))),1)
I put it at the top left corner of the table.
My rows are generated by =100000*BETA.INV(RAND(),2,3)
My columns are 1,2,3,4...
Any idea?
The formula works on a single cell but it does not work when it generates the table.
Thanks!
I made a data table and it generates DIV errors.
Are there any limitations when using data tables?
How do we specify the formula we want to use?
My formula is:
=MIN($C$8/(C4*INDEX('Part 2'!$C$26:$AS$47,3,MATCH($C$2+'Part 2'!$C$6+1,'Part 2'!$C$26:$AS$26))+C4*(1+INDEX('Part 2'!$C$26:$AS$47,3,MATCH($C$2+'Part 2'!$C$6+1,'Part 2'!$C$26:$AS$26)))*INDEX('Part 2'!$C$26:$AS$47,3,MATCH($C$2+'Part 2'!$C$6+2,'Part 2'!$C$26:$AS$26))+C4*(1+INDEX('Part 2'!$C$26:$AS$47,3,MATCH($C$2+'Part 2'!$C$6+1,'Part 2'!$C$26:$AS$26)))*(1+INDEX('Part 2'!$C$26:$AS$47,3,MATCH($C$2+'Part 2'!$C$6+2,'Part 2'!$C$26:$AS$26)))*INDEX('Part 2'!$C$26:$AS$47,3,MATCH($C$2+'Part 2'!$C$6+3,'Part 2'!$C$26:$AS$26))+INDEX('Part 2'!$C$26:$AS$47,18,MATCH($C$2+'Part 2'!$C$6,'Part 2'!$C$26:$AS$26))),1)
I put it at the top left corner of the table.
My rows are generated by =100000*BETA.INV(RAND(),2,3)
My columns are 1,2,3,4...
Any idea?
The formula works on a single cell but it does not work when it generates the table.
Thanks!