Results 1 to 7 of 7
Thread: Ôîðìóëà çà Excel
Hybrid View
-
25th November 2009 23:35 #1Registered User
Join Date: Nov:2009
Location: Ïëîâäèâ
Posts: 2
Ôîðìóëà çà Excel
Çäðàâåéòå ìîëÿ çà ïîìîù!!!
Èìàì ñëåäíèÿò êàçóñ çà ðåøàâàíå èìàì òàáëèöà, â êîÿòî òðÿáâà äà âúâåæäàì ðàçìåðè è ñïðÿìî òåçè ðàçìåðè äà ñå ïîëó÷àâàò äðóãè ðàçìåðè
Ïðèìåð:
ñòîéíîñòè ïî ãîëåìè îò 500 â êëåòêàòà À1 òðÿáâà äà ñå èçïèøå òåêñò â êëåòêà Â1 "40õ100"
Ñòîéíîñòè îò 500 äî 400 - "40õ80"
Ñòîéíîñòè îò 400 äî 300 - "40õ60"
Ñòîéíîñòè îò 300 äî 250 - "40õ40"
è äî 250 - "40õ20"
Íåçíàì äà ëè å âúçìîæíî íî èñêðåííî ñå íàäÿâàì äà ñå ïîëó÷è!
Áëàãîäàðÿ Âè ïðåäâàðèòåëíî!
-
26th November 2009 00:59 #2
Ïðîáâàé ñ òîâà:
Òàçè ôîðìóëà ÿ ïèøè â B1, à ÷èñëàòà â À1Code:=IF(A1<250;"40x20";IF(A1<=300;"40x40";IF(A1<=400;"40x60";IF(A1<=500;"40x80";IF(A1>500;"40x100";)))))
Ôîðìóëàòà íå å äîèçïèïàíà (â ñìèñúë äîðè è äà íÿìà íèùî íàïèñàíî â À1 òÿ ïàê ñè ïîêàçâà ðåçóëòàò 40x20), òàêà ÷å àêî íà íÿêîé ìó ñå çàíèìàâà äà ÿ ïîîïðàâè, ÷å íà ìåí ìè ñå äîñïà...Last edited by todorpavlov; 26th November 2009 at 01:11.
MB: ASRock K7 EZ upgrade | CPU: AMD Athlon XP 2200+ clocked to 2800+ | VC: ATi Radeon 9550 | RAM: 2x A-DATA 256 MB in Dual Channel Mode | HDD: Exelsor 80GB + Seagate 120 GB | TV tuner: PlayTV Pro2 | DVD-RW: NEC 3550 CD-RW: LG 8525B | LanCard: Compaq NC3121 10/100MB |
-
26th November 2009 10:49 #3
Last edited by aniuta; 26th November 2009 at 10:54.
...à äíåñ ìîÿ ñîáñòâåí íàñëåäíèê, èçâúðøâà ãåðîéñêè áåëè,
íå ñúì ñå èçãóáèë áåçñëåäíî, ùîì òîé ìå ïîâòàðÿ... íàëè?
-
26th November 2009 14:07 #4
Last edited by todorpavlov; 26th November 2009 at 14:18.
MB: ASRock K7 EZ upgrade | CPU: AMD Athlon XP 2200+ clocked to 2800+ | VC: ATi Radeon 9550 | RAM: 2x A-DATA 256 MB in Dual Channel Mode | HDD: Exelsor 80GB + Seagate 120 GB | TV tuner: PlayTV Pro2 | DVD-RW: NEC 3550 CD-RW: LG 8525B | LanCard: Compaq NC3121 10/100MB |
-
26th November 2009 01:13 #5
Âúçìîæíî å, ïîòúðñè çà óïîòðåáàòà íà nested IFs â excel, â êîìáèíàöèÿ ñ AND.
<Gigabyte 8I945P Pro> <Intel P-D 930> <2x1 GB Cîrsair DDR2 667> <Galaxy GF 7300GT>
-
26th November 2009 21:53 #6Registered User
Join Date: Nov:2009
Location: Ïëîâäèâ
Posts: 2
Ìîì÷åòà ÁËÀÃÎÄÀÐß ÂÈ ÍÀÉ-ÈÑÊÐÅÍÎ ÂÈÅ ÑÒÅ ÑÓÏÅÐ!!!!
---------- Äîáàâåí ïîñëåäâàù êîìåíòàð â 21:40 ---------- Îðèãèíàëíèÿò êîìåíòàð å ïóñíàò â 18:16 ----------
À íåùî çà çàêðúãëÿíå ñëåä îïðåäåëåíà ôóíêöèÿ
íàïðèìåð
=SUM(D8-22)/5+1 ñëåä òîçè ðåçóëòàò òðÿáâà äà ñå çàêðúãëè ñëåä 2-ðèÿ çíàê?
Íåùî íå ìîãà äà êîìáèíèðàì äâå ôóíêöèè!
---------- Äîáàâåí ïîñëåäâàù êîìåíòàð â 21:53 ---------- Îðèãèíàëíèÿò êîìåíòàð å ïóñíàò â 21:40 ----------
À íåùî çà çàêðúãëÿíå ñëåä îïðåäåëåíà ôóíêöèÿ
íàïðèìåð
=SUM(D8-22)/5+1 ñëåä òîçè ðåçóëòàò òðÿáâà äà ñå çàêðúãëè ñëåä 2-ðèÿ çíàê?
Íåùî íå ìîãà äà êîìáèíèðàì äâå ôóíêöèè!
-
26th November 2009 21:56 #7Banned
Join Date: Jun:2008
Location: Ñòàðà Çàãîðà
Posts: 1,880




Reply With Quote

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