[請問] Excel含小數2位的亂數函數:－2016[心得] 韓劇Top10排行榜想再看一部韓劇希望大家推薦[新聞] 韓劇史上收視率最高韓劇前50位排行榜

Blogtrottr

批踢踢實業坊 ask 板

Apr 2nd 2014, 19:41, by fishmemory

作者fishmemory (莫瑞瑞)

看板ask

標題[請問] Excel含小數2位的亂數函數

時間Wed Apr 2 19:41:42 2014

研究了很久都沒辦法順利跑出來想要的數字只好上來求救Excel高手們我需要一組函數，可產生20個不同的亂數要包含小數後兩位並在某兩個數字之間例如這個區間 9.70-10.3 (10的正負0.3) 應該出現: 9.8 10 10.21 等等使用Excel 2007 謝謝 -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 36.231.196.98 ※ 文章網址: http://www.ptt.cc/bbs/ask/M.1396438905.A.5F2.html

→ wxtab019:=RANDBETWEEN(970,1030)/100 04/02 19:48

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions