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

Array index for sequences

  • October 22, 2022
  • 6 replies
  • 2455 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

 

 

6 replies

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

 

Terms & ConditionsAccessibility statement