RANDBETWEENé¢æ°ã使ã£ã¦ä¹±æ°ãä½æããæ¹æ³ããç´¹ä»ãã¾ããã RANDBETWEENé¢æ°ã¯åæãã¼ã«ã¢ãã¤ã³ã«å«ã¾ããé¢æ°ã§ããããã¢ãã¤ã³ãçµã¿è¾¼ã¾ãã¦ããªãå ´åã¯å©ç¨ã§ãã¾ããã åæãã¼ã«ã¢ãã¤ã³ãçµã¿è¾¼ã¾ãã¦ããªãå ´åãä¹±æ°ãä½æããæ¨æºã®ã¯ã¼ã¯ã·ã¼ãé¢æ°ãå©ç¨ãã¦ãã ãããRANDé¢æ°ã§ãã ä½ããã®RANDé¢æ°ã¯ã0以ä¸1æªæºã®å°æ°ã®ä¹±æ°ãä½æããã ããªã®ã§ãRANDBETWEENé¢æ°ã®ããã«ç¯å²ãæå®ããä¹±æ°ãã»ããå ´åã«ã¯ãæ°å¼ã工夫ããå¿ è¦ãããã¾ãã ããã§aããbã®ç¯å²ã§å°æ°ãå«ãã ä¹±æ°ãä½æããã¾ããããæ´æ°ã®ä¹±æ°ã«ããã®ã§ããã°ãINTé¢æ°ãTRUNCé¢æ°ãªã©ã使ãã°OKã§ãã ä¾ãã°ã5ãã10ã®ä¹±æ°ãä½æããã®ã§ããã°ã ã=INT(RAND()*(10-5)+5)ã ã¾ã㯠ã=TRUNC(RAND()*(10-5)+5)ã ã¨ããã°ããããã§ãã
{{#tags}}- {{label}}
{{/tags}}