Results 1 to 11 of 11
Thread: Âúïðîñ çà Excel
Hybrid View
-
3rd September 2011 17:55 #1Registered User
Join Date: Aug:2011
Location: BG
Posts: 21
Âúïðîñ çà Excel
Çäðàâåéòå èìàì åäíà òàáëèöà â êîÿòî äàííèòå (öèôðîâè) ñà ïîïúëíåíè ñ òî÷êè à íå ñúñ çàïåòàéêè (íàïðèìåð: 5.25 âìåñò 5,25) ïðè êîåòî ôîðìóëàòà íå ãî ñìÿòà ïðàâèëíî. èìà ëè íà÷èí äà ãè ïîïðàâÿ âñè÷êèòå íà âåäíúæ èëè íåùî äðóãî... Öåëòà å äà èçáåãíà ðåäàêòèðàíåòî èì 1 ïî 1 ÷å ñà äîñòà.
-
3rd September 2011 17:58 #2
Ctrl+H ?
Íå îòãîâàðÿì íà íåãðàìîòíè ïîñòîâå. Äà èçòèêàìå HWBG ïàïëà÷òà! Êîïèðàéòå ãî â ïîäïèñà ñè, çà äà ñè âúðíåì ôîðóìà.
Èìàì ñè áëîã è ñè ëàÿ â íåãî
-
3rd September 2011 18:36 #3Registered User
Join Date: Aug:2011
Location: BG
Posts: 21
Ñòàíà áëàãîäàðÿ òè!
-
9th October 2011 15:49 #4
Äðóãàðè, èìàì è àç åäíî ïèòàíå. Îïèòâàì ñå äà èçìèñëÿ ôîðìóëà çà ñëåäíîòî óñëîâèå:  êîëîíà äà ìîãàò äà ñå âúâåæäàò ÷èñëà ìåæäó 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
-
9th October 2011 16:45 #5Registered 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)
-
9th October 2011 20:51 #6Registered 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




Reply With Quote
Íå âúçìîæíîñò äà èçêëþ÷à êîìïþòúðà
7th May 2023, 16:02 in Îáù ôîðóì çà PC õàðäóåð