Results 1 to 23 of 23
Thread: Ôîðìóëà íà Excel, êàê...
Hybrid View
-
11th February 2012 15:48 #1Registered User
Join Date: Oct:2005
Location: mars
Posts: 266
Ôîðìóëà íà Excel, êàê...
êàk äà íàïèøà òàÿ ôîðìóëà if(A1:A3>4; "ok"; "no") ,
÷å äà ðàáîòè ...
-
11th February 2012 17:12 #2Registered User
Join Date: Jun:2005
Location: Âàðíà
Posts: 62
=IF(SUM(A1:A3)>4;"Da";"Ne")
-
13th February 2012 19:58 #3
Òîé ìàé èìà ïðåäâèä àêî íÿêîå îò ïîëåòàòà îò à1 äî à3 å ïîâå÷å îò 4, à íå àêî ñáîðà èì å ïî-ãîëÿì. Òîãàâà íàé-õèòðî ùå áúäå IF(MAX(A1:À3)>4;"ok";"no")
Asrock B365 Pro4; Intel Core i5-9400F; Kingston HyperX 2x16Gb DDR4; Gigabyte Aorus GTX 1080ti
-
15th February 2012 23:23 #4Registered User
Join Date: Oct:2005
Location: mars
Posts: 266
-
18th April 2012 20:01 #5
Íÿêîé ìîæå ëè äà ïîìîãíå ñ èç÷èñëÿâàíå íà ñóìàðíî âðåìå?
Òèÿ âñè÷êèòå èñêàì äà ãè ñúáåðà è ðåçóëòàòúò äà å â ìèíóòè.
Gigabyte X570 AORUS Ultra | 5950X | Arctic Liquid Freezer II 240 | Corsair Vengeance LPX 2x8GB 3200Mhz | Samsung 980 Pro 1TB + Samsung 970 Pro 1TB | Gigabyte AORUS GeForce RTX 3080 Ti Master 12GB | Fractal Design Meshify C Dark TG | Corsair AX860i | Samsung U32H850 32" 4K
-
19th April 2012 11:15 #6
Ïðåäëàãàì äà ñè íàïðàâèø îùå åäíà êîëîíêà äî íåÿ, â êîèòî äà êîíâåðòèðàø òåêñòà â ìèíóòè, êîèòî ïîñëå äà ñóìèðàø. Ìîæå äà ïîëçâàø ñëåäíàòà ôîðìóëà:
=VALUE(LEFT(A1;FIND("m";A1)-1))+VALUE(MID(A1;FIND("m";A1)+2;FIND("s" ;A1)-FIND("m";A1)-2))/60Asrock B365 Pro4; Intel Core i5-9400F; Kingston HyperX 2x16Gb DDR4; Gigabyte Aorus GTX 1080ti
-
13th February 2012 20:12 #7
Êàêâî çíà÷è "A1:A3>4"? Åäíà îò êëåòêèòå å ïî-ãîëÿìà (ïîëçâàø OR), âñè÷êèòå êëåòêè ñà ïî-ãîëåìè (ïîëçâàø AND), ñóìàòà ïî-ãîëÿìà (ïîëçâàø âàðèàíòà íà e}{treme), íåùî äðóãî (ïîÿñíè).
åäèò: Àêî èìà ïîâå÷å îò 3-4 ïîëåòà îïðåäåëåíî òâîÿòà èäåÿ çà max/min âúðøè ïî-äîáðà ðàáîòà. Âàæíîòî å äà çíàå êàêâî èñêà äà íàïðàâè
-
13th February 2012 20:14 #8
Àêî ïîëçâà AND è OR òðÿáâà äà èçðåæäà âñè÷êèòå êëåòêè. Ïî-äîáðå äà ïîëçâà MAX è MIN.
Asrock B365 Pro4; Intel Core i5-9400F; Kingston HyperX 2x16Gb DDR4; Gigabyte Aorus GTX 1080ti




Reply With Quote

Äðàçíåù LOG â Ìèêðîòèê
6th May 2023, 12:03 in Ìðåæè