On 29/12/2011 at 15:09, csanyipal <[email protected]> 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: [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
