Results 1 to 6 of 6

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Aug:2007
    Location: Stara Zagora
    Posts: 5

    EXEL ïèòàíêà!

    òîâà êîåòî ìå òîðìîçè å áæ. ñíèìêàòà
    Âúïðîñà å êàê ñëåä êàòî ñå ðàçäåëè ñóìàòà è ñå ïîëó÷è ðàçëèêà äà ñòàíå òàêà,÷å åêñåë äà ñè íàïðàâè ïðîâåðêà è êîðåêöèÿ íà äâåòå ïîñëåäíè êîëîíè òàêà ÷å äà íå ñå ïîëó÷àâà ðàçëèêà!
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	123.JPG‎ 
Views:	358 
Size:	77.9 KB 
ID:	20359  

  2. #2
    S.T.A.R.S. James0888's Avatar
    Join Date: Jan:2004
    Location: Ñîôèÿ
    Posts: 3,073
    Quote Originally Posted by kernelpanic View Post
    òîâà êîåòî ìå òîðìîçè å áæ. ñíèìêàòà
    Âúïðîñà å êàê ñëåä êàòî ñå ðàçäåëè ñóìàòà è ñå ïîëó÷è ðàçëèêà äà ñòàíå òàêà,÷å åêñåë äà ñè íàïðàâè ïðîâåðêà è êîðåêöèÿ íà äâåòå ïîñëåäíè êîëîíè òàêà ÷å äà íå ñå ïîëó÷àâà ðàçëèêà!
    Íàïðàâèë ëè ñè ROUNDUP? È ñå ïèøå Excel.
    My last Tower: [24/7] [PXP35] [E6500@4026MHz] [ST@1500rpm] [Corsair 8GB DDR2] [GTX280 1GB OC] [Black Diamond 850W] [VelociRaptor 600GB]
    ITX rig 10 years later: [24/7] [B450M ITX] [Ryzen 5 3600@4400MHz] [Corsair 32GB 3600MHz] [KFA2 RTX3060Ti 8GB] [Corsair CX550SF] [1TB WD Black SN850]

  3. #3
    Registered User
    Join Date: Aug:2007
    Location: Stara Zagora
    Posts: 5
    íàïðàâèë ñúì ROUND(êëåòêà,0)

  4. #4
    Registered User Áåë÷åâ's Avatar
    Join Date: Dec:2007
    Location: íà ñåëî
    Posts: 939
    Èçâèíÿâàì ñå, ÷å "âäèãàì" ñòàðà òåìà, íî äà íå ïðàâÿ íîâà...!
    Èìàì åäèí òàêúâ âúïðîñ: Íèç îò êëåòêè â êîëîíà, ñ ðåçóëòàòè ïîëó÷åíè ÷ðåç ðàçíàñÿíå íà ôîðìóëà çà óìíîæåíèå ñ äðóãà êëåòêà. Ïîíåæå ñà ìè íóæíè öåëè ÷èñëà, ïðàâÿ çàêðúãëÿíå íà ðåçóëòàòèòå. Êàê äà íàïðàâÿ òàêà, ùîòî ñáîðà îò ÷èñëàòà íà êëåòêèòå â òàçè êîëîíà, äà ìè ñå èç÷èñëÿâà, êàòî ñáîð îò òåçè çàêðúãëåíè ÷èñëà, à íå ðåàëíèÿò, îò ïðåäè çàêðúãëÿíåòî?
    Ùå çàêà÷à ôàéëà, çàùîòî íå çíàì äîáðå ëè ãî îáÿñíèõ.
    Ñòàâà âúïðîñ çà êëåòêà E73, à â êëåòêà E74, å ñáîðà îò öåëèòå ÷èñëà.
    0111.xls

  5. #5
    Registered User
    Join Date: Aug:2009
    Location: Ñîôèÿ
    Posts: 265
    Code:
    =SUMPRODUCT(ROUND(E4:E72;0))

  6. #6
    Registered User Áåë÷åâ's Avatar
    Join Date: Dec:2007
    Location: íà ñåëî
    Posts: 939
    Avis, ìíîãî òè áëàãîäàðÿ è äîáðå äîøúë âúâ ôîðóìà!

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 | Ìàãàçèí çà åëåêòðîííè öèãàðè