Results 1 to 23 of 23

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Oct:2005
    Location: mars
    Posts: 266

    Ôîðìóëà íà Excel, êàê...

    êàk äà íàïèøà òàÿ ôîðìóëà if(A1:A3>4; "ok"; "no") ,
    ÷å äà ðàáîòè ...

  2. #2
    Registered User
    Join Date: Jun:2005
    Location: Âàðíà
    Posts: 62
    =IF(SUM(A1:A3)>4;"Da";"Ne")

  3. #3
    Registered User mertol's Avatar
    Join Date: Jan:2011
    Location: sofia
    Posts: 2,927
    Òîé ìàé èìà ïðåäâèä àêî íÿêîå îò ïîëåòàòà îò à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

  4. #4
    Registered User
    Join Date: Oct:2005
    Location: mars
    Posts: 266
    Quote Originally Posted by mertol View Post
    Òîé ìàé èìà ïðåäâèä àêî íÿêîå îò ïîëåòàòà îò à1 äî à3 å ïîâå÷å îò 4, à íå àêî ñáîðà èì å ïî-ãîëÿì. Òîãàâà íàé-õèòðî ùå áúäå IF(MAX(A1:À3)>4;"ok";"no")
    òîâà ìè òðÿáâàøå , áëàãîäàðÿ

  5. #5
    Registered User CYPER's Avatar
    Join Date: May:2004
    Location: Ðóñå
    Posts: 9,356
    Íÿêîé ìîæå ëè äà ïîìîãíå ñ èç÷èñëÿâàíå íà ñóìàðíî âðåìå?

    Òèÿ âñè÷êèòå èñêàì äà ãè ñúáåðà è ðåçóëòàòúò äà å â ìèíóòè.

    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

  6. #6
    Registered User mertol's Avatar
    Join Date: Jan:2011
    Location: sofia
    Posts: 2,927
    Ïðåäëàãàì äà ñè íàïðàâèø îùå åäíà êîëîíêà äî íåÿ, â êîèòî äà êîíâåðòèðàø òåêñòà â ìèíóòè, êîèòî ïîñëå äà ñóìèðàø. Ìîæå äà ïîëçâàø ñëåäíàòà ôîðìóëà:
    =VALUE(LEFT(A1;FIND("m";A1)-1))+VALUE(MID(A1;FIND("m";A1)+2;FIND("s" ;A1)-FIND("m";A1)-2))/60
    Asrock B365 Pro4; Intel Core i5-9400F; Kingston HyperX 2x16Gb DDR4; Gigabyte Aorus GTX 1080ti

  7. #7
    Come get some! DukeFan's Avatar
    Join Date: Jan:2003
    Location: Áúëãàðèÿ
    Posts: 1,763
    Êàêâî çíà÷è "A1:A3>4"? Åäíà îò êëåòêèòå å ïî-ãîëÿìà (ïîëçâàø OR), âñè÷êèòå êëåòêè ñà ïî-ãîëåìè (ïîëçâàø AND), ñóìàòà ïî-ãîëÿìà (ïîëçâàø âàðèàíòà íà e}{treme), íåùî äðóãî (ïîÿñíè).

    åäèò: Àêî èìà ïîâå÷å îò 3-4 ïîëåòà îïðåäåëåíî òâîÿòà èäåÿ çà max/min âúðøè ïî-äîáðà ðàáîòà. Âàæíîòî å äà çíàå êàêâî èñêà äà íàïðàâè

  8. #8
    Registered User mertol's Avatar
    Join Date: Jan:2011
    Location: sofia
    Posts: 2,927
    Àêî ïîëçâà AND è OR òðÿáâà äà èçðåæäà âñè÷êèòå êëåòêè. Ïî-äîáðå äà ïîëçâà MAX è MIN.
    Asrock B365 Pro4; Intel Core i5-9400F; Kingston HyperX 2x16Gb DDR4; Gigabyte Aorus GTX 1080ti

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