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

On 29/12/2011 at 15:09, csanyipal <csanyipal@gmail.com> 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 averages formulas refers to different ranges. Take a look (best 
viewed with monospace font):
AVERAGE(AC6:AC17;AC19:AC20;AD29)
AVERAGE(AD6:AD17;AD19:AD20;AD29)
                  ^     ^       ^       ^

If you adjust ranges in complex formula to be the same as ranges in simpler 
formula, they will produce the same output.
-- 
Best regards
Mirosław Zalewski

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
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