Results 1 to 5 of 5

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered 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 è òí

    Ñòàâà âúïðîñ çà äîñòà ðåäîâå, à è ÷åñòî ìè ñå íàëàãà äà ñìåíÿì äèàïàçîíà.

  2. #2
    Registered User
    Join Date: Oct:2003
    Location: Ñîôèÿ
    Posts: 4,317
    http://www.google.bg/search?q=excel+random+numbers
    Ðàçáèðà ñå, òåçè ÷èñëà íå ñà èñòèíñêè ñëó÷àéíè, à ñà ò.íàð. ïñåâäîñëó÷àéíè. Íî ïî÷òè ñèãóðíî ñà äîñòàòú÷íè çà öåëèòå òè.
    Âòîðèÿ âúïðîñ, "äà ñå ïîëó÷è è â ðåä", íå ãî ðàçáèðàì.

  3. #3
    Registered User
    Join Date: Mar:2009
    Location: Plovdiv
    Posts: 37
    Ñ ôóíêöèÿòà RAND ãåíåðèðàì îáà÷å òåçè ñà ñàìî ïîëîæèòåëíè ,à íà ìåí ìè òðÿáâàò è îòðèöàòåëíè ñòîéíîñòè.

  4. #4
    Registered User
    Join Date: Oct:2003
    Location: Ñîôèÿ
    Posts: 4,317
    Çàòîâà å èçìèñëåíà àðèòìåòèêàòà.
    =int(rand()*10)-5

  5. #5
    Registered User
    Join Date: Mar:2009
    Location: Plovdiv
    Posts: 37
    Áàø çà òîâà å èçìèñëåíà

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè