Re: [libreoffice-users] AVERAGE calculation differs when alone or in a complex formula?

2011-12-29 Thread Jay Lozier
Pal, On 12/29/2011 09:09 AM, csanyipal wrote: Hi, I'm trying to figure out why differs AVERAGE calculations when using it alone in a cell or when using it in a complex formula? http://nabble.documentfoundation.org/file/n3618892/Average_Problem.ods Average_Problem.ods In the .ods abowe on the

Re: [libreoffice-users] AVERAGE calculation differs when alone or in a complex formula?

2011-12-29 Thread Mirosław Zalewski
On 29/12/2011 at 15:09, csanyipal wrote: > 'AD30' > =IF(OR(COUNTIF(AD6:AD17;"=1");COUNTIF(AD19:AD20;"=1");COUNTIF(AD29;"=1"));" > 0";AVERAGE(AC6:AC17;AC19:AC20;AD29)) > > and in the > > 'AD46' > =AVERAGE(AD6:AD17;AD19:AD20;AD29) > > cells are different. How could it be? Because these averag

[libreoffice-users] AVERAGE calculation differs when alone or in a complex formula?

2011-12-29 Thread csanyipal
Hi, I'm trying to figure out why differs AVERAGE calculations when using it alone in a cell or when using it in a complex formula? http://nabble.documentfoundation.org/file/n3618892/Average_Problem.ods Average_Problem.ods In the .ods abowe on the sheet '17.' one can see that that AVERAGE calcul