Skip to main content
MS_104648891-Visitor
1-Visitor
October 22, 2022
Solved

Array index for sequences

Hello, how should i properly set array index, so that my sequence is calculated? 

Werner_E
Werner_EAnswer
25-Diamond I
October 22, 2022

In case you insist on doing the calcs on worksheet level using a range variable, here are two ways:

1)

Werner_E_1-1666457511143.png

 

2)

Werner_E_2-1666457545516.png

 

 

View in thread

6 replies

Werner_E
Werner_E25-Diamond I
25-Diamond I
October 22, 2022

There may be easier ways to generate vectors with alternating Fibonacci numbers 😉

Is it a typo that you used index j*1 instead of just j or did you mean j-1?

Translate
MS_104648891-VisitorAuthor
1-Visitor
October 22, 2022

its not meant to be fibonacci numbers, its just something random to test how sequences work here. I dont know how to get around K and D sequences not being initialized at the same time

Translate
Werner_E
Werner_E25-Diamond I
25-Diamond I
October 22, 2022

This does not answer my question if your j*1 just means j or if you wanted to type j-1

A assume the first and would suggest using a generating function to do the job

Werner_E_0-1666457318423.png

 

Translate
Terms & ConditionsAccessibility statement