Thread
:
Random Number comparison
View Single Post
#
2
Posted to microsoft.public.excel.programming
Barb Reinhardt
external usenet poster
Posts: 54
Random Number comparison
I'd copy and paste the first column of data so that when you recalculate,
you don't lose your numbers.
Create another column of random numbers.
=if(a1B1,"Less",if(a1<b1,"More",Equal))
"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
Reply With Quote
Barb Reinhardt
View Public Profile
Find all posts by Barb Reinhardt