Skip to main content
14-Alexandrite
November 28, 2014
Solved

Display the index value

  • November 28, 2014
  • 9 replies
  • 2688 views

Hello,

In the attached sheet, please scroll down to the red arrow. is there a way you can display the index value for "W". Thanks!

Best answer by Werner_E

Maybe using "explicit" does what you want. n must not defined a value to make it work.

1.png

You can also make it look like this

2.png

9 replies

19-Tanzanite
November 28, 2014

What do you mean by "the index for each W based on the n value?" The index is either n-2, n-1, n, n+1, or n+2.

SFares14-AlexandriteAuthor
14-Alexandrite
November 28, 2014

for example to display when n=3, to plug in that value and get or display W1,W2,W3,W4,,W5 .

Werner_E
Werner_E25-Diamond IAnswer
25-Diamond I
November 28, 2014

Maybe using "explicit" does what you want. n must not defined a value to make it work.

1.png

You can also make it look like this

2.png

SFares14-AlexandriteAuthor
14-Alexandrite
November 28, 2014

Thank you Werner!

every time i use subsitute, do i need to use explicit with it?

SFares14-AlexandriteAuthor
14-Alexandrite
November 28, 2014

Werner,

why doesn't it work if i define a value for as i did earlier, and then use explicit, n w/o subsitute? just trying to understand how things work!