질문하기

Davidb's profile - activity

2015-10-17 00:27:58 +0200 받은 배지  주목할 만한 질문 (source)
2015-10-17 00:27:58 +0200 받은 배지  유명한 질문 (source)
2015-10-17 00:27:58 +0200 받은 배지  인기있는 질문 (source)
2015-08-24 14:59:32 +0200 받은 배지  정리의 달인
2012-07-03 10:33:45 +0200 질문하였습니다 Random cell selection

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..