Excel Functions Nesting

[Pallavi2603]

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

[#2]

@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))