Well I no how to use randbetwenn with numbers but I have some words in different cells is there anyway I can do a randbetween with those
Thanks

Nope, RandBetween takes only numeric values as its parameters. What is it you are trying to accomplish?

ScottGem is right... there is no single function that will do what you're asking. However, you can probably make use of the randbetween function in an indirect way to get what you want. For example:

Code:

---

=CHOOSE(RANDBETWEEN(1,4),A11,A12,A13,A14)

---

This will randomly choose the value of some given cells. The limit of the "CHOOSE" function is 29 cells.

Use

=INDEX($A1:$A10,RANDBETWEEN(1,COUNTA($A1:$A10)),1)

for randomly choosing a word from columns A1-A10. Of course, you can change this to any rows or columns you need. Just change the formula accordingly.