Hi all,
I have some text that reads like
if ([x - (1)] *1.00001 > [X])
{
asdfasdfadsf
}
All in Cell A1
where x and asdfasdfadsf are irrelevant text.
I'm looking to replicate this over and over, increasing the (1) by 1 every time until 50,000.
Each replication should be placed in the cell below.
Note that 1.0001 remains unchanged.
So Cell A2 would read
if ([x - (2)] *1.00001 > [X])
{
asdfasdfadsf
}
Cell A3 would read
if ([x - (3)] *1.00001 > [X])
{
asdfasdfadsf
}
.......
And Cell A50000 would read
if ([x - (50000)] *1.00001 > [X])
{
asdfasdfadsf
}
Any and all help appreciated!
Bookmarks