Hi I have a range of 6 differing short texts I want to have displayed at random in response to an input.
Easy to show just the one text, but I want to not always have the same predictable result.
For a single line =IF (A1>0,D3) works fine, but I have 5 alternative responses at D4 to D9 I would like each of the 5 alternate texts randomly used instead of just the one at D3 every time…
I think I have to use the Rand function, but dont quite know how go about it… any ideas please…
Hello… Try this
=IF(A1>0,OFFSET(D4,INT(RAND()*5),0),"")
Works here.
You can also try other variants:
=IF(A1>0;INDIRECT("D"&(3+RANDBETWEEN(1;6)));"No variants")
=IF(A1>0;INDEX(D4:D9;RANDBETWEEN(1;COUNTA(D4:D9));1);"")