Results 1 to 4 of 4

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Dec:2011
    Location: Sofia
    Posts: 148

    Excel 2010 - àâòîìàòè÷íî èç÷èñëÿâàíå

    Ïðèâåò. Íåçíàì êàê íàé - ïðàâèëíî äà ñè çàäàì âúïðîñà, çàòîâà ïðèêà÷âàì òàçè ñíèìêà: Click image for larger version. 

Name:	4659074Z.png 
Views:	149 
Size:	7.4 KB 
ID:	51531 Òàêà.  êîëîíàòà "Ñòîéíîñò" ñå óìíîæàâàò êëåòêèòå íà Êîëè÷åñòâîòî è Åäèíè÷íàòà öåíà. Êàê äà íàïðàâÿ àâòîìàòè÷íî äà ìè ñå èç÷èñëÿâà ñòîéíîñòòà, à â ñúùîòî âðåìå êëåòêèòå â êîëîíàòà Ñòîéíîñò äà ñà ïðàçíè, äåìåê äà íå ïèøå 0,00, êîãàòî íå ñúì ïîïúëíèë Ê-âîòî è Åä.öåíà.

  2. #2
    èíæ. ìàãüîñíèê worm4's Avatar
    Join Date: Jul:2005
    Location: Varna
    Posts: 20,312
    Code:
    =if(ôîðìóëà=0;"";ôîðìóëà;)
    ôîðìóëà òè å ñåãàøíàòà
    "Arbeit macht frei" -òîëóïà òèêâåí
    Èäèîò - Òîâà å ÷îâåê ñ èäåè. Àêî ñúì ïðîïóñíàë ïðåïèíàòåëíè çíàöè, òóê èìà ðåçåðâíè:..,,--?!
    OgiDogi: Çàìåðâà ñå ñ ÿéöà, ÿáúëêè, êàìúíè è ò.í., à åëåêòðè÷åñêèòå âåëè÷èíè ñå èçìåðâàò

  3. #3
    Registered User the_first_one's Avatar
    Join Date: Dec:2003
    Location: Brussels
    Posts: 207
    Quote Originally Posted by worm4 View Post
    Code:
    =if(ôîðìóëà=0;"";ôîðìóëà;)
    ôîðìóëà òè å ñåãàøíàòà
    Êàòî àëòåðíàòèâà - Options -> Advanced -> Display options for this worksheet -> ðàçìàðêèðàø "Show a zero in cells that have zero values".

    Òîâà å íàñòðîéêà çà êîíêðåòåí ôàéë, à íå ãëîáàëíà çà Excel.

  4. #4
    Registered User
    Join Date: Dec:2011
    Location: Sofia
    Posts: 148
    Ñòàíà. Áëàãîäàðÿ âè ìíîãî.

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