Gal milijardams skaiciuoti yra kitokie duomenu tipai nei double, su daug maziau skaiciu po kablelio, kartu su ju apvalinimo aloritmais? "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...:( >>>>> >>>> >>>> >>> > >