Results 1 to 5 of 5
Thread: ïîìîù çà EXCEL 2003
Hybrid View
-
16th March 2009 17:01 #1
ïîìîù çà 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 ìè èçïèñâà ,÷å èìà ãðåøêà!
íÿêîé çíàå ëè êàêâà ìîæå äà å ïðè÷èíàòà ?
-
16th March 2009 17:08 #2Banned
Join Date: Jun:2008
Location: Ñòàðà Çàãîðà
Posts: 1,880
Äî êîëêîòî çíàì Excel ïîçâîëÿâà äî 7 âëîæåíè åäíà â äðóãà ôóíêöèè.
-
16th March 2009 17:41 #3
-
16th March 2009 18:47 #4
thnx ìíîãî çà èçÿñíåíèåòî. ùå ðàçó÷à hlookup
-
16th March 2009 20:27 #5
Ïðîáâàé ñ
=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)Æèâîòúò å õóáàâ!




Reply With Quote

Ïðîáëåìíà R9 280, àðòåôàêòè
7th May 2023, 21:28 in Âèäåîêàðòè