View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 54
Default 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