Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
Hi to all
I am trying to extract values from an array named DATA and look them up in another called Table_1, and then do operations.
By manually entering the row and variables of the DATA array, I get what was expected, but when I want to do it automatically, and have the data array be extracted and compared row by row, I don't get the expected results.
I attach the spreadsheet with the exercise.
I hope you can help me.
Solved! Go to Solution.
You forgot to initialize "MPot" to zero, so the values of the previous calculation remained in that variable.
I've only got Prime so can't play with your program (or even get it to evaluate), however, you might want to try debugging by taking your program outside of your new 'i' loop and call it from within the loop (ie, automate your manual evaluation). You could use the row operator to set the return matrix for each i.
Stuart
You forgot to initialize "MPot" to zero, so the values of the previous calculation remained in that variable.