Results 1 to 5 of 5

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User lisi4ko's Avatar
    Join Date: Nov:2008
    Location: Varna
    Posts: 91

    ïîìîù çà EXCEL 2003

    Èìàì ñëåäíèÿ âúïðîñ...èìà ëè íÿêàêâî îãðàíè÷åíèå íà OR èëè AND ôóíêöèèòå â äàäåíà êëåòêà?
    Â ñëåäíàòà ôîðìóëêà:

    =IF(AND(OR(B5=J1;B5=K1);B8=L1);L3;IF(AND (OR(B5=J1;B5=K1);B8=M1);M3;IF(AND(OR(B5= J1;B5=K1);B8=N1);N3;IF(AND(OR(B5=J1;B5=K 1);B8=O1);3;IF(AND(OR(B5=J1;B5=K1);B8=P1 );P3;IF(AND(OR(B5=J1;B5=K1);B8=Q1);Q3;IF (AND(OR(B5=J1;B5=K1);B8=R1);R3;0)))))))

    ìè äàâà ãðåøêà è âåäíàãà ñëåä òîâà ìè highlight-âà ïîëñåäíàòà ô-ÿ OR.
    Êàòî ìàõíà ïîñëåäíàòà IF ô-ÿ (êúäåòî å è OR-a) ñå îïðàâÿ!òàêà ñè ðàáîòè->

    =IF(AND(OR(B5=J1;B5=K1);B8=L1);L3;IF(AND (OR(B5=J1;B5=K1);B8=M1);M3;IF(AND(OR(B5= J1;B5=K1);B8=N1);N3;IF(AND(OR(B5=J1;B5=K 1);B8=O1);3;IF(AND(OR(B5=J1;B5=K1);B8=P1 );P3;IF(AND(OR(B5=J1;B5=K1);B8=Q1);Q3;0) )))))

    È ñ äðóãè ôîðìóëè ñúì ïðîáâàë (ïåðèîäè÷êî ïîâòàðÿùå ñå)...ñëåä íÿêîëêî ïîâòîðåíèÿ íà OR ìè èçïèñâà ,÷å èìà ãðåøêà!

    íÿêîé çíàå ëè êàêâà ìîæå äà å ïðè÷èíàòà ?

  2. #2
    Banned
    Join Date: Jun:2008
    Location: Ñòàðà Çàãîðà
    Posts: 1,880
    Äî êîëêîòî çíàì Excel ïîçâîëÿâà äî 7 âëîæåíè åäíà â äðóãà ôóíêöèè.

  3. #3
    Çâåðî÷îâåêîïðèçðàê pimpirlit's Avatar
    Join Date: Mar:2004
    Location: Ñîôèÿ
    Posts: 21,712
    Quote Originally Posted by ven_stoich View Post
    Äî êîëêîòî çíàì Excel ïîçâîëÿâà äî 7 âëîæåíè åäíà â äðóãà ôóíêöèè.
    Òî÷íî. À ãîðíàòà ôîðìóëà ìîæå äà ñòàíå ìíîãî ïî-ëåñíî ñ hlookup() ôóíêöèÿòà (íå ñúì ñå çàäúëáî÷àâàë, íî òàêà ìèñëÿ).
    Æèâîòúò å õóáàâ!

  4. #4
    Registered User lisi4ko's Avatar
    Join Date: Nov:2008
    Location: Varna
    Posts: 91
    thnx ìíîãî çà èçÿñíåíèåòî. ùå ðàçó÷à hlookup

  5. #5
    Çâåðî÷îâåêîïðèçðàê pimpirlit's Avatar
    Join Date: Mar:2004
    Location: Ñîôèÿ
    Posts: 21,712
    Ïðîáâàé ñ

    =IF(OR(B5=J1;B5=K1);HLOOKUP(B8;L1:R3;3;F ALSE);0)

    Íåäîñòàòúê å, ÷å àêî èìàø ñúâïàäåíèå íà B5=J1 èëè B5=K1, íî íÿìàø íà B8 ñ íÿêîå îò L1 äî R1 (èëè äîêúäåòî èñêàø) ùå òè âàäè #N/A âìåñòî 0. Àêî òîâà å ïðîáëåì, ìîæå äà ñòàíå äîñòà ïî-òðîìàâîòî

    =IF(AND(OR(B5=J1;B5=K1);(NOT(ISNA(HLOOKU P(B8;L1:R3;3;FALSE)))));HLOOKUP(B8;L1:R3 ;3);0)
    Æèâîòúò å õóáàâ!

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