Results 1 to 2 of 2

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User shmatkata's Avatar
    Join Date: Feb:2008
    Location: bulgaria
    Posts: 262

    ïèòàíå çà excel ôîðìóëà

    íÿêîé ìîæå ëè äà ìè êàæå ôîðìóëà â excel ñúñ êîÿòî ùå ìîãà äà íàïðàâÿ ñëåäíîòî:
    êëåòêà 1 èìàìå íàäïèñ, êëåòêà 2 èìàìå öèôðà è â êëåòêà 3 àêî âúâåäà áóêâàòà Y äà ñå ïîÿâÿâà â äàäåíà äðóãà êëåòêà íàäïèñà èëè öèôðàòà.
    Àêî å N äà íå ñå ïîÿâÿâà.
    N è Y äà å êàòî yes è no àìà íå çíàì äàëè ìîæå äà ñå ïðàâè òàêèâà íåùà ñúñ excel.

  2. #2
    -=Øåìåò=-
    Join Date: Sep:2003
    Location: Ñîôèÿ
    Posts: 6,444
    =IF(ISBLANK(B1),A1,B1)
    He who asks is a fool for five minutes, but he who does not ask reamins a fool forever. Old Chinese saying
    Quote Originally Posted by worm4 View Post
    Áúëãàðèíà íà ïúòÿ å òúïî æèâîòíî äåòî ìó ñå ñêúñÿâà ïèøêaòà êàòî ãî èçïðåâàðÿò.

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