M
Mike
Hi everyone,
Say you have equation like this X+Y=Alpha, where X in a cell A1 with a random value defined by Randbetween(1,50), and Y in a next cell B1 with a random value defined by Randbetween(2,20), and Alpha in C1 = A1+B1
Every time you hit F9, you get a new value to Alpha. Now, say you highlight A1, B1, C1 and scroll down to row #100 for example.
So, every time you hit F9, you get instantaneous 100 values to Alpha. It is like in-parallel computing, but is it so or what is instantaneous computing called if there is a name?
If none of that, how is this instantaneous computing done in Excel?
Thanks,
Mike
Say you have equation like this X+Y=Alpha, where X in a cell A1 with a random value defined by Randbetween(1,50), and Y in a next cell B1 with a random value defined by Randbetween(2,20), and Alpha in C1 = A1+B1
Every time you hit F9, you get a new value to Alpha. Now, say you highlight A1, B1, C1 and scroll down to row #100 for example.
So, every time you hit F9, you get instantaneous 100 values to Alpha. It is like in-parallel computing, but is it so or what is instantaneous computing called if there is a name?
If none of that, how is this instantaneous computing done in Excel?
Thanks,
Mike