Hopefully this is a very basic question. There may be a simpler way to solve my problem, so I'll go over that first then ask the question I'm trying to ask.
My problem: I want A1=0 A2=1 A3=2 ... A500=499
My thought is to do something like "=[A:This-1]+1" where This is the number of the cell I'm currently working in. Is there a 'This' variable equivalent? Or some way to say always use the cell above instead of having to go through all 500 cells and count?