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

Array index for sequences

  • October 22, 2022
  • 1 reply
  • 2422 views

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

Best answer by Werner_E

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

 

 

1 reply

W
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?

M
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

W
Werner_E25-Diamond IAnswer
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

 

 

    Terms & ConditionsCookie settingsAccessibility statement