Help with WHILE loops

mappryan · Aug 18, 2011

I am very inexperienced with while loops. I am trying to write a loop that checks all the answers in a vector and if they are "OK" then it outputs "OK". I keep getting an "array index invalid for this array problem". I have written a simplified example of this problem to post here. If someone could please take a look and explain what I am doing wrong it would be greatly appreciated. I believe it is due to my lack of knowledge/experience with using a while loop altogether. Thank you

zdas04 · Aug 18, 2011

I don't see where you assign any value to "vec". If I make start and end different from each other the error goes away and vec_location has a value in the output (the value is the next cell after the end of the while).

David

mappryan · Aug 18, 2011

well vec is not defined because I am using it as a function and therefore it isnt required to be defined. The origin has something to do with this problem as if i set the origin to zero in worksheet preferences both work. I think I have some sort of misunderstanding of the array indexing that I was hoping someone could clarify

IRstuff · Aug 18, 2011

No, it's due to the fact that your x cannot terminate your WHILE, resulting in the index going above 10. In fact, no vector with a 0 in the last location will terminate the WHILE.

TTFN

FAQ731-376
Chinese prisoner wins Nobel Peace Prize

mappryan · Aug 18, 2011

IRstuff thank you. I realize what is wrong now. To fix it I am guessing there needs to be an otherwise statement added to the IF statement but I can't seem to get that to work. Any ideas of what i can do

IRstuff · Aug 18, 2011

Either that, or you put the index increment at the start and start with zero. Or, you figure out at the start what the maximum allowable index can be.

TTFN

FAQ731-376
Chinese prisoner wins Nobel Peace Prize

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Help with WHILE loops

mappryan

Structural

Recommended for you

zdas04

Mechanical

mappryan

Structural

IRstuff

Aerospace

mappryan

Structural

IRstuff

Aerospace

Similar threads

Part and Inventory Search

Sponsor