Results 1 to 5 of 5
Thread: Ãåíåðèðàíå íà ÷èñëà â Exsel
Hybrid View
-
28th March 2011 11:45 #1Registered User
Join Date: Mar:2009
Location: Plovdiv
Posts: 37
Ãåíåðèðàíå íà ÷èñëà â Exsel
Êàê ìîãà äà ãåíåðèðàì ñëó÷àéíè ÷èñëà â îïðåäåëåí äèàïàçîí ïðèìåðíî îò -5 äî +5 è äà ñå ïîëó÷è ñëåäíîòî
-1
2
0
3
-4
-2
2
è òí
à ñúùî òàêà äàëè ìîæå ðåçóëòàòà äà ñå ïîëó÷è è â ðåä ïðèìåðíî
-2 5 1 -3 -2 1 4 2 è òí
Ñòàâà âúïðîñ çà äîñòà ðåäîâå, à è ÷åñòî ìè ñå íàëàãà äà ñìåíÿì äèàïàçîíà.
-
28th March 2011 11:51 #2Registered User
Join Date: Oct:2003
Location: Ñîôèÿ
Posts: 4,317
http://www.google.bg/search?q=excel+random+numbers
Ðàçáèðà ñå, òåçè ÷èñëà íå ñà èñòèíñêè ñëó÷àéíè, à ñà ò.íàð. ïñåâäîñëó÷àéíè. Íî ïî÷òè ñèãóðíî ñà äîñòàòú÷íè çà öåëèòå òè.
Âòîðèÿ âúïðîñ, "äà ñå ïîëó÷è è â ðåä", íå ãî ðàçáèðàì.
-
28th March 2011 13:04 #3Registered User
Join Date: Mar:2009
Location: Plovdiv
Posts: 37
Ñ ôóíêöèÿòà RAND ãåíåðèðàì îáà÷å òåçè ñà ñàìî ïîëîæèòåëíè ,à íà ìåí ìè òðÿáâàò è îòðèöàòåëíè ñòîéíîñòè.
-
28th March 2011 13:07 #4Registered User
Join Date: Oct:2003
Location: Ñîôèÿ
Posts: 4,317
Çàòîâà å èçìèñëåíà àðèòìåòèêàòà.
=int(rand()*10)-5
-
28th March 2011 13:26 #5Registered User
Join Date: Mar:2009
Location: Plovdiv
Posts: 37
Áàø çà òîâà å èçìèñëåíà




Reply With Quote
Íå âúçìîæíîñò äà èçêëþ÷à êîìïþòúðà
7th May 2023, 16:02 in Îáù ôîðóì çà PC õàðäóåð