Results 1 to 5 of 5
Thread: Ôóíêöèÿ â Excel
Hybrid View
-
30th July 2009 22:42 #1Registered User
Join Date: Apr:2006
Location: Gabrovo
Posts: 42
Ôóíêöèÿ â Excel
Çäðàâåéòå, íÿêîé ùå ìîæå ëè äà ìè ïîìîãíå ìàëêî ñ Excel :]
Íà ïúðâàòà ñòðàíèöà èìàì êàòàëîã ñ ïðîäóêòè - êàòàëîæåí íîìåð, íàèìåíîâàíèå, îïèñàíèå, êîëè÷åñòâî è ò.í.
Èñêàì äà íàïðàâÿ òàêà, ÷å êîãàòî íà âòîðàòà ñòðàíèöà íàïèøåø êàòàëîæåí íîìåð äà òè èçâåäå èíôîðìàöèÿòà çà íåãî îò ïúðâà ñòðàíèöà.
Äî íÿêúäå óñïÿõ äà ãî íàïðàâÿ ñ ôóíêöèÿòà VLOOKUP ïî òîçè óðîê:
http://www.youtube.com/watch?v=vgb_rdI67Zs
íî òàêà, êîãàòî âúâåäà íîìåð, êîéòî ãî íÿìà â ïúðâà ñòðàíèöà, ìè èçâåæäà ñòîéíîñòèòå îò äðóã íîìåð.
-
30th July 2009 23:38 #2Registered User
Join Date: Oct:2003
Location: Ñîôèÿ
Posts: 4,317
http://office.microsoft.com/bg-bg/ex...093351026.aspx
Íàé-âåðîÿòíî íå ñè èçïîëçâàë FALSE çà ïîñëåäíèÿ ïàðàìåòúð.
-
30th July 2009 23:49 #3
+1
×åòâúðòèÿò ïàðàìåòúð íà ôóíêöèÿòà òðÿáâà äà å FALSE (èëè åêâèâàëåíòúò ìó çà ñúîòâåòíàòà åçèêîâà âåðñèÿ íà îôèñà).
Òîé íå å çàäúëæèòåëåí, íî àêî ãî íÿìà ñå ïîäðàçáèðà TRUE - è ñå âçåìà íàé-áëèçêàòà íàëè÷íà ñòîéíîñò.24/7 Asus P9X79 Deluxe+H2O i7-3930K @4625 MHz+H2O 64 GB Geil DDR3 11-12-12-30/2333 MHz+H2O 2*HD7970 VaporX 6 GB+H2O ROG Phoebus+Onkyo HT-S990 THX RAID0:2*256 GB Samsung 830 SSD+RAID0:4*1TB WD1000DHTZ+..EXTs CM HAF-X Seasonic SS-1250XM Gold 1250W Logitech G15 Gaming+G9x 30" Dell 3007WFP-HC @2560x1600
-
31st July 2009 15:25 #4Registered User
Join Date: Apr:2006
Location: Gabrovo
Posts: 42
Áëàãîäàðÿ.
À ìîãà ëè äà íàïðàâÿ ôóíêöèÿòà çà öÿëàòà êîëîíà è êîãàòî íÿìà ñòîéíîñò äà íå ìè èçâåæäà N/A à ïðîñòî êëåòêàòà äà îñòàíå ïðàçíà?
Ñúùî è ìîãà ëè äà èçâàäÿ ñòîéíîñòèòå îò ïîâå÷å îò åäíà êîëîíà(âìîìåíòà èçïîëçâàì 2 ïúòè VLOOKUP çà äà èçâåäà äâå êîëîíè)
Ïðèêà÷èõ ïðèìåðåí ôàéë, ñ òîâà êîåòî ñúì íàïðàâèë äî ñåãà.Last edited by firefly; 31st July 2009 at 15:30.
-
31st July 2009 15:29 #5
Íå ìè ñå ÷åòàò ïðèìåðíè ôàéëîâå.
ISNA(êëåòêà) - ïðîâåðÿâà äàëè â òàçè êëåòêà ñòîéíîñòòà å N/A.
Çà äà äàäåø äðóãà ñòîéíîñò - ïîëçâàø IF
Âñåêè VLOOKUP å îò åäíà êîëîíà - èíà÷å ìîæåø äà êîíêàòåíèðàø (çàëåïèø) ñòðèíãîâåòå âúðíàòè îò òÿõ.24/7 Asus P9X79 Deluxe+H2O i7-3930K @4625 MHz+H2O 64 GB Geil DDR3 11-12-12-30/2333 MHz+H2O 2*HD7970 VaporX 6 GB+H2O ROG Phoebus+Onkyo HT-S990 THX RAID0:2*256 GB Samsung 830 SSD+RAID0:4*1TB WD1000DHTZ+..EXTs CM HAF-X Seasonic SS-1250XM Gold 1250W Logitech G15 Gaming+G9x 30" Dell 3007WFP-HC @2560x1600




Reply With Quote
Lenovo ThinkPad 15 èëè IdeaPad 15
5th May 2023, 22:16 in Ìîáèëíè êîìïþòðè