Rand Formula explaination

Hello Guys,

 

I hope your all doing great!, Am lookin for some help in creating Random paragraphes in the same cell , I did a formula to generate random praragraphs but its not giving me a value . The idea is that we want to take cell from column 1 and we want to combine cell from column 2 and add the last column , Here is the formula and what am trying to do 

=CHOOSE(250,CHOOSE(RANDBETWEEN(1,10),$A$2,$A$3,$A$4,$A$5,$A$6,$A$7,$A$8,$A$9,$A$10),CHOOSE(RANDBETWEEN(1,10),$B$2,$B$3,$B$4,$B$5,$B$6,$B$7,$B$8,$B$9,$B$10))

p1 p2 p3  
Yazan 1 Younes 1 Yazan and younes 1 #VALUE!
Yazan 2 Younes 2 Yazan and younes 2
Yazan 3 Younes 3 Yazan and younes 3
Yazan 4 Younes 4 Yazan and younes 4
Yazan 5 Younes 5 Yazan and younes 5
Yazan 6 Younes 6 Yazan and younes 6
Yazan 7 Younes 7 Yazan and younes 7
Yazan 8 Younes 8 Yazan and younes 8
Yazan 9 Younes 9 Yazan and younes 9

By: Yazan

Leave a Reply

Your email address will not be published. Required fields are marked *