You could try this
ToolsOptionsCalculation and check the Iteration box to stop circular
references
Adjust your randomising formula, in a manner like this
=IF(($B$1="")+(A10),A1,INT(RAND()*100+1))
Add my formula =SUMPRODUCT(--(A1:A99<A2:A100)) in another cell
then put some value in B1
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Bob Phillips" wrote in message
...
If the range of numbers is in A1:A100, use
=SUMPRODUCT(--(A1:A99<A2:A100))
for higher
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Philip Morritt" <Philip wrote in
message
...
I am trying to compare a randomly generated number by the previous
randomly
generated number in the same cell. I would like to know if the new
number
is
higher or lower than the provious number. Once known i would like to
add
up
these occurances. ie out of 100 calculations 45 were higher and 55 were
lower. 45 and 55 should be shown in the next cells. Any suggestions
would
be a great help.
Philip Morritt
University West England Bristol