Tema: Q: Openoffice calc formule Err:514
Autorius: Paul_
Data: 2009-03-03 11:31:41
Sveiki,

Sukuriau gana ilga formule su IF() reiksme ir nebeleidzia man jos praplesti/papildyti naujais kriterijais, meta klaida: Err:514 " Sort operation attempted on too much numerical data (max. 100000) or a calculation stack overflow.."
Fomules pavyzdys:

IF(A1=95;"aleliuja";(IF(A1=99;"nera";.........(IF(A1=795;"taskas";"")))))))) 

Koks yra formules zenklu limitas? 
Kaip butu galima praplesti formule?
HELP: Excelaruva2009-03-03 20:23
+Acronis true image nedirba..cD-r0m2009-03-03 17:07
REQ: Acronis instrukcijaMatas2009-03-03 15:46
+REQ: Acronis instrukcijaMatas2009-03-03 15:43
+Vaistu Firestreamer, DVstreamer..cD-r0m2009-03-03 15:27
-Q: Openoffice calc formule Err:514Paul_2009-03-03 11:31
Re: Openoffice calc formule Err:514c\(0,O\)o2009-03-03 13:22
[req] pakvietimo pas linkomanussarelis@work2009-03-03 09:43
+del Kasperiozenia2009-03-02 22:37
ESXi backupavimasWolf@W2009-03-02 15:41
+netbook sinchronizacijavytux[86]2009-03-02 00:27
Help Win XP Pro kodo nepriima...gompis2009-03-01 22:03
+Firefox nuotraukos kėlimas į e-mailą.Inco2009-03-01 13:17
+vaistuku 2007-tam ofisui0802009-03-01 04:22
+Mozilla Thunderbird ir Firefox duomen saugojimo vietagompis2009-02-28 15:23
+Nod32 update serverisYksas2009-02-28 08:55
Q:Koki softa naudoti?magnus_dux2009-02-27 16:35
+task manager programos.Edgaras2009-02-27 13:06
+Q: OEM licenzija?Abrakadabra2009-02-27 10:46
+Po antivirusines instaliavimo, WINXP Home DEP ismetaYZF2009-02-27 10:18
Q:"nero vision dvd" per "ms media plaeyr'i" nera garso?Abrakadabra2009-02-27 09:37
+Kaip paleisti skirtingas Acrobat Reader versijas viename PCzenia2009-02-27 09:22
+reikia programelesSergejus2009-02-27 08:25
gal kas matet kurnors "nevietoj" padeta plugina kuris ArcView suGPSimtuvusujungtu?ZHP2009-02-26 19:51
+free VPN client for Vistam.k.2009-02-26 15:32
Kaip sinchronizuoti failusRemigijus2009-02-26 11:42
ar imanoma ?laptopas kaip wireless marsrutizatorius3brolis2009-02-26 11:20
+back-up softukasm.k.2009-02-26 09:30
+nero overburn dvd+rATT2009-02-25 16:37
+Q: skubus : Exel 2007 - kaip istrinti tik atfiltruotas eilutes, o ne visas?raibutis2009-02-25 14:53
+Q: admino passLabaiNeSpauda2009-02-25 11:41
Q: WIN XP x64 activation tool?MN2009-02-25 07:49
+uTorrent nepatinka kazhkasDedmytas2009-02-24 19:24
+REQ LinkomanijaRokas2009-02-24 18:41
+req: smulkus klausimas apie excelAlmantas2009-02-24 16:49
+Avira vs AvastSvajoklis2009-02-24 16:34
+Q: offiso nemokama alternatyva windowsams?Abrakadabra2009-02-24 16:26
+Ikyrus OERivo2009-02-24 15:41
+hdd image winxp +linuxm.k.2009-02-24 14:56
+Skype stabdo kompaNT2009-02-24 14:06
+Pagalbos del acer ferrari 4000Simonas2009-02-24 00:12
+Q: ExcelJoint_as2009-02-23 18:15
+OFF REQ: linkomanijos pakvietimasjohnrembo2009-02-23 17:12
+kaip dainuot i kompiuter?Galvos Daktaras2009-02-23 16:53
+HELP: ASUS 686 ir SDHCLaputis2009-02-23 15:17