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 sheet '17.' one can see that that AVERAGE
calculations in the
'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)
One is (mostly) averaging the data in column AC and the other is using
column AD. Since the data in each column is not the same the answers
will be different.
cells are different. How could it be?
-----
Best Regards from
Pál
--
View this message in context:
http://nabble.documentfoundation.org/AVERAGE-calculation-differs-when-alone-or-in-a-complex-formula-tp3618892p3618892.html
Sent from the Users mailing list archive at Nabble.com.
--
Jay Lozier
[email protected]
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
