Results 1 to 3 of 3

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User pwq's Avatar
    Join Date: Jan:2007
    Location: Ñîôèÿ
    Posts: 188

    Âúïðîñ çà Åxcel?

    Ïðè èçâàæäàíå íà äâå ïî äâå ÷èñëà â êîëîíà, êîãàòî îùå íå å âúâåäåíî ñëåäâàùîòî ÷èñëî, â ïîëåòî çà ðåçóëòàòàò èçëèçàò ñèìâîëè èëè íóëà. Êàê äà íàïðàâÿ òàêà, ÷å ïîëåòî ñ ðåçóëòàòà äà å ïðàçíî, äîêàòî íå ñå âúâåäå ñëåäâàùî ÷èñëî è àêî ðåçóëòàòà å ïîëîæèòåëåí äà èìà çíàê "+" ïðåä íåãî.

  2. #2
    a.k.a. Bibi Flower's Avatar
    Join Date: Aug:2006
    Location: Sofia, Bulgaria
    Posts: 562

    Re: Excel

    Ïî ïúðâèÿ âúïðîñ òàêà:
    =IF(ISBLANK(A1),"",A1-A0)

    Ïî âòîðèÿ:
    Format -> Cells
    Èçáèðàø "Custom" è ïèøåø
    +0;-0

  3. #3
    Registered User
    Join Date: Nov:2008
    Location: BG
    Posts: 24
    Quote Originally Posted by pwq View Post
    Ïðè èçâàæäàíå íà äâå ïî äâå ÷èñëà â êîëîíà, êîãàòî îùå íå å âúâåäåíî ñëåäâàùîòî ÷èñëî, â ïîëåòî çà ðåçóëòàòàò èçëèçàò ñèìâîëè èëè íóëà.....[/img]
    Ñúùî òàêà ñè ôîðìàòèðàé ïðàâèëíî âñè÷êè ïîëåòà. Ìîãà äà òè ïðåïî÷ðú÷àì âñè÷êè äà ñà "Custom". Òàêà îòðèöàòåëíèòå ÷èñëà ùå áóäàò â ÷åðâåíî. à îñòàíàëèòå â êàêúâòî öâÿò èñêàø.

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