Nu jo :) "Gvi2" <gvi2@work.lt> wrote in message news:hdgfkb$hqo$1@trimpas.omnitel.net... > Nematau nieko kvailo. Jei atidžiau pažiūrėsi, pamatysi, kad visi šie > limit'ai > ir turi po 15 reikšminių skaitmenų (iki E) :-) > > "Veygr" <noname@nothing.net> wrote in message > news:hde5ah$1f2$1@trimpas.omnitel.net... >> taip ir yra. kvailiausia yra tai, kad VBA palaiko >> duomenu formata Double, kurio ribos yra: >> Double (double-precision floating-point) variables are stored as IEEE >> 64-bit >> (8-byte) floating-point numbers ranging in value >> from -1.79769313486231E308 >> to -4.94065645841247E-324 for negative values and from >> 4.94065645841247E-324 >> to 1.79769313486232E308 for positive values. >> Be to, VBA turi funkcija FomatNumber, kur gali nurodyti skaiciu ilgi >> iki 1024 simboliu, bet daryk, ka nori, vis vien virs 15 neima ir nerodo. >> Taip, kad kas skaiciuoja simtais milijardu pinigus, bukit budrus. Galimos >> paklaidos virs kablelio :) >> >> veygr >> >> "Gvi2" <gvi2@work.lt> wrote in message >> news:hddtqi$k8f$1@trimpas.omnitel.net... >>> Ir neparodys. >>> Ištrauka iš Excel Help'o: >>> >>> Precision is a measure of the degree of accuracy for a calculation. >>> Excel stores and calculates with 15 significant digits of precision. >>> >>> O tavo rezultate jau 19 reikšminių skaitmenų. >>> >>> >>> "LwJ" <LwJ@Nera.Lt> wrote in message >>> news:hddm0b$895$1@trimpas.omnitel.net... >>>> Kalkuliatorius ok, bet va excel'is galo...1375 niekaip nesugeba >>>> parodyti...:) >>>> "MinVodai" <minvodai@gmail.com> wrote in message >>>> news:hdc0jd$lnh$1@trimpas.omnitel.net... >>>>> tai gal perdaug protinga turi :) >>>>> Nustates koki HEX :) >>>>> o gal OCT, bet tada negaletum ivest 8 ir 9 >>>>> tai papasakok kokia velniava ten gauni? :) >>>>> >>>>> "LwJ" <LwJ@Nera.Lt> wrote in message >>>>> news:hd93pe$jr7$1@trimpas.omnitel.net... >>>>>> Kai paskai?iuoji su kalkuliatorium tada gaunasi velniava >>>>>> "gannet" <kas@cia.lt> wrote in message >>>>>> news:hd90le$djo$1@trimpas.omnitel.net... >>>>>>>o kas negerai? >>>>>>> 301,72 ? (tiksliau: 301,7200000000001375) >>>>>>> >>>>>>> LwJ wrote: >>>>>>>> Sveiki, >>>>>>>> tokia vat nesamone, sudauginkite excel'yje 21425 ir >>>>>>>> 0,0140826137689615 >>>>>>>> man kazkokia velniava gaunasi...:( >>>>>> >>>>> >>>>> >>>> >> >>