Hello everybody, here is a brain teaser for you:
I am trying to repeat the same if/then conditional statement about 1000 times, each time using a different row. I would like to know if I have to manually enter each instance of the conditional statement or if there is a shortcut. The only difference is the rows that it is reading from and writing to. Here is the statement:
Basically, each cell referred to would be one row down for each instance. For example, if I was to type it manually it would look like:
As you can see, each number just increases by one. Is there a shortcut to typing each one out?
Many thanks in advance!