about iterations

Occasional Visitor

hi i am ali;

how can i do that

in A4 cell=randomly number

in A5 cell=IF(A4*A5<0;choose a new number)

so I have many data. I am choosing randomly but the first number times the second one has to be less than 0. 

1 Reply
Can you try explaining again, I don't understand the question sorry. A screenshot can be really helpful. Thankyou