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
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
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