Results 1 to 7 of 7

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered 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"

    Íåçíàì äà ëè å âúçìîæíî íî èñêðåííî ñå íàäÿâàì äà ñå ïîëó÷è!
    Áëàãîäàðÿ Âè ïðåäâàðèòåëíî!

  2. #2
    Drinkin' Master todorpavlov's Avatar
    Join Date: Jun:2006
    Location: Batak, Bulgaria
    Posts: 373
    Ïðîáâàé ñ òîâà:

    Code:
    =IF(A1<250;"40x20";IF(A1<=300;"40x40";IF(A1<=400;"40x60";IF(A1<=500;"40x80";IF(A1>500;"40x100";)))))
    Òàçè ôîðìóëà ÿ ïèøè â B1, à ÷èñëàòà â À1

    Ôîðìóëàòà íå å äîèçïèïàíà (â ñìèñúë äîðè è äà íÿìà íèùî íàïèñàíî â À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 |

  3. #3
    Registered User aniuta's Avatar
    Join Date: Apr:2004
    Location: Ïëîâäèâ
    Posts: 1,058
    Quote Originally Posted by todorpavlov View Post
    Ôîðìóëàòà íå å äîèçïèïàíà (â ñìèñúë äîðè è äà íÿìà íèùî íàïèñàíî â À1 òÿ ïàê ñè ïîêàçâà ðåçóëòàò 40x20), òàêà ÷å àêî íà íÿêîé ìó ñå çàíèìàâà äà ÿ ïîîïðàâè, ÷å íà ìåí ìè ñå äîñïà...
    Code:
    =IF(A1<=0;"";IF(A1<250;"40x20";IF(A1<=300;"40x40";IF(A1<=400;"40x60";IF(A1<=500;"40x80";IF(A1>500;"40x100";))))))
    Last edited by aniuta; 26th November 2009 at 10:54.
    ...à äíåñ ìîÿ ñîáñòâåí íàñëåäíèê, èçâúðøâà ãåðîéñêè áåëè,
    íå ñúì ñå èçãóáèë áåçñëåäíî, ùîì òîé ìå ïîâòàðÿ... íàëè?

  4. #4
    Drinkin' Master todorpavlov's Avatar
    Join Date: Jun:2006
    Location: Batak, Bulgaria
    Posts: 373
    Quote Originally Posted by aniuta View Post
    Code:
    =IF(A1<=0;"";IF(A1<250;"40x20";IF(A1<=300;"40x40";IF(A1<=400;"40x60";IF(A1<=500;"40x80";IF(A1>500;"40x100";))))))

    È àç òîâà ñå ñåòèõ, àìà íàëè å ïèñàë "è äî 250", íå áÿõ ñèãóðåí äàëè ùå ïîëçâà è îòðèöàòåëíè ÷èñëà...


    ÅÄÈÒ @evlogi: À, è äðóãî, àêî íàïèøåø "300" êîëêî òðÿáâà äà èçëèçà 40õ40 èëè 40õ60, ñúîòâåòíî è çà äðóãèòå 250, 400, 500
    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 |

  5. #5
    M.A.V.O. Member Tele_Santana's Avatar
    Join Date: Jun:2005
    Location: downtown
    Posts: 205
    Âúçìîæíî å, ïîòúðñè çà óïîòðåáàòà íà nested IFs â excel, â êîìáèíàöèÿ ñ AND.
    <Gigabyte 8I945P Pro> <Intel P-D 930> <2x1 GB Cîrsair DDR2 667> <Galaxy GF 7300GT>

  6. #6
    Registered 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-ðèÿ çíàê?
    Íåùî íå ìîãà äà êîìáèíèðàì äâå ôóíêöèè!

  7. #7
    Banned
    Join Date: Jun:2008
    Location: Ñòàðà Çàãîðà
    Posts: 1,880
    Quote Originally Posted by evlogi View Post
    =SUM(D8-22)/5+1 ñëåä òîçè ðåçóëòàò òðÿáâà äà ñå çàêðúãëè ñëåä 2-ðèÿ çíàê?
    Íåùî íå ìîãà äà êîìáèíèðàì äâå ôóíêöèè!
    =ROUND(SUM(D8-22)/5+1;2)

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