Excel Functions Nesting

Occasional Visitor
Can a CHOOSE(RANDBETWEEN()) fx be nested within a IF fx as its condition, to generate multiple random text outputs?
1 Reply

@Pallavi2603 

You can use something like

=CHOOSE(RANDBETWEEN(1,5),"Mary","Had","A","Little","Lamb")

You can get the same result using

=INDEX({"Mary","Had","A","Little","Lamb"},RANDBETWEEN(1,5))