Results 1 to 11 of 11

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Aug:2011
    Location: BG
    Posts: 21

    Âúïðîñ çà Excel

    Çäðàâåéòå èìàì åäíà òàáëèöà â êîÿòî äàííèòå (öèôðîâè) ñà ïîïúëíåíè ñ òî÷êè à íå ñúñ çàïåòàéêè (íàïðèìåð: 5.25 âìåñò 5,25) ïðè êîåòî ôîðìóëàòà íå ãî ñìÿòà ïðàâèëíî. èìà ëè íà÷èí äà ãè ïîïðàâÿ âñè÷êèòå íà âåäíúæ èëè íåùî äðóãî... Öåëòà å äà èçáåãíà ðåäàêòèðàíåòî èì 1 ïî 1 ÷å ñà äîñòà.

  2. #2
    Íàñòîÿù øåô íà Èíòåë Joredos's Avatar
    Join Date: May:2003
    Location: Ñîôèÿ
    Posts: 5,202
    Ctrl+H ?
    Íå îòãîâàðÿì íà íåãðàìîòíè ïîñòîâå. Äà èçòèêàìå HWBG ïàïëà÷òà! Êîïèðàéòå ãî â ïîäïèñà ñè, çà äà ñè âúðíåì ôîðóìà.
    Èìàì ñè áëîã è ñè ëàÿ â íåãî

  3. #3
    Registered User
    Join Date: Aug:2011
    Location: BG
    Posts: 21
    Ñòàíà áëàãîäàðÿ òè!

  4. #4
    Ronnie James Dio Snow's Avatar
    Join Date: Jun:2005
    Location: Ñîôèÿ
    Posts: 8,221
    Äðóãàðè, èìàì è àç åäíî ïèòàíå. Îïèòâàì ñå äà èçìèñëÿ ôîðìóëà çà ñëåäíîòî óñëîâèå:  êîëîíà äà ìîãàò äà ñå âúâåæäàò ÷èñëà ìåæäó 0.20 è 1.40, íî ñúñ ñòúïêè 0.03 ìåæäó òÿõ. Ò.å. ñàìî 0.2, 0.23, 0.26 ... 1.37, 1.4.
    Íåùî íå óñïÿâàì äà ãî èçìèñëÿ, íèòî ïúê äà ñè ïîìîãíà ñ Google. Ìîëÿ çà ïîìîù (:

    Áëàãîäàðÿ ïðåäâàðèòåëíî.
    MSI B550i Gaming Edge Wifi | Ryzen 9 5900X [Thermalright AXP-100C65 + Noctua A9x14] | G.Skill 2x16GB F4-3200C16Q-32GTZR | AMD RX 6800XT | EVO970 500GB + EVO850 250GB + EVO850 500GB + DS119j | Corsair SF750 Platinum | ASUS MG279Q | Razer DeathAdder V2 Pro | Keychron K6 Modded | SligerSM550

  5. #5
    Registered User
    Join Date: Aug:2009
    Location: Ñîôèÿ
    Posts: 265
    Åäèíèÿò âàðèàíò å äà ãî íàïèøåø íÿêúäå êàòî ñïèñúê (ñàìî 41 ñòîéíîñòè ñà), äà ìó äàäåø èìå è äà çàäàäåø Data Validation ñ List. Äðóãèÿò å òèïà íà Data Validation äà å Custom, ñ ôîðìóëà îò òîçè òèï (çà êëåòêà A1):
    Code:
    =AND(A1>=0.2;A1<=1.4;MOD(A1*100-20;3)=0)

  6. #6
    Registered User
    Join Date: Aug:2005
    Location: Bugaria
    Posts: 652
    Çäðàâåéòå,
    Ùå èçïîëçâàì òåìàòà çà äà ïèòàì íåùî.
    Èñêàì â EXSEL êàòî âúâåäà íåùî, â ñúñåäíàòà êëåòêà äà ñå ïîÿâÿâà òåêóùàòà äàòà.
    È äàëè òîâà å âúçìîæíî â google docs?
    Ïîðîâèõ äîñòà , íî íåùî íå íàìèðàì ðåøåíèÿ
    Last edited by GACO; 9th October 2011 at 21:28.
    Case: Lancool-215 /MB: Asus Prime B450- Plus/CPU: AMD Ryzan 5800X3D /GeForce RTX™ 4090 GAMING OC / PSU: Super Flower Leadex III 750W /2x16GB DDR4 3600 Kingston FURY/LG 27GL850-B/TV LG OLED 55B9 / VR: HP Reverb 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 | Ìàãàçèí çà åëåêòðîííè öèãàðè