Results 1 to 6 of 6
Thread: EXEL ïèòàíêà!
Hybrid View
-
20th March 2009 09:36 #1Registered User
Join Date: Aug:2007
Location: Stara Zagora
Posts: 5
EXEL ïèòàíêà!
òîâà êîåòî ìå òîðìîçè å áæ. ñíèìêàòà
Âúïðîñà å êàê ñëåä êàòî ñå ðàçäåëè ñóìàòà è ñå ïîëó÷è ðàçëèêà äà ñòàíå òàêà,÷å åêñåë äà ñè íàïðàâè ïðîâåðêà è êîðåêöèÿ íà äâåòå ïîñëåäíè êîëîíè òàêà ÷å äà íå ñå ïîëó÷àâà ðàçëèêà!
-
20th March 2009 10:08 #2My 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]
-
20th March 2009 10:53 #3Registered User
Join Date: Aug:2007
Location: Stara Zagora
Posts: 5
íàïðàâèë ñúì ROUND(êëåòêà,0)
-
17th September 2009 00:55 #4
Èçâèíÿâàì ñå, ÷å "âäèãàì" ñòàðà òåìà, íî äà íå ïðàâÿ íîâà...!
Èìàì åäèí òàêúâ âúïðîñ: Íèç îò êëåòêè â êîëîíà, ñ ðåçóëòàòè ïîëó÷åíè ÷ðåç ðàçíàñÿíå íà ôîðìóëà çà óìíîæåíèå ñ äðóãà êëåòêà. Ïîíåæå ñà ìè íóæíè öåëè ÷èñëà, ïðàâÿ çàêðúãëÿíå íà ðåçóëòàòèòå. Êàê äà íàïðàâÿ òàêà, ùîòî ñáîðà îò ÷èñëàòà íà êëåòêèòå â òàçè êîëîíà, äà ìè ñå èç÷èñëÿâà, êàòî ñáîð îò òåçè çàêðúãëåíè ÷èñëà, à íå ðåàëíèÿò, îò ïðåäè çàêðúãëÿíåòî?
Ùå çàêà÷à ôàéëà, çàùîòî íå çíàì äîáðå ëè ãî îáÿñíèõ.
Ñòàâà âúïðîñ çà êëåòêà E73, à â êëåòêà E74, å ñáîðà îò öåëèòå ÷èñëà.
0111.xls
-
17th September 2009 08:55 #5Registered User
Join Date: Aug:2009
Location: Ñîôèÿ
Posts: 265
Code:=SUMPRODUCT(ROUND(E4:E72;0))
-
17th September 2009 10:26 #6
Avis, ìíîãî òè áëàãîäàðÿ è äîáðå äîøúë âúâ ôîðóìà!




Reply With Quote

Ïðåïîðú÷àéòå ìÿñòî çà ïî÷èâêà â...
07.05.23 ã., 14:24 in Îáùè ïðèêàçêè