In the local help for Calc the descriptions of AND and OR on the page Logical Functions say:
"If a range is entered as a parameter, the function uses the value from the range that is in the current column or row."
This is wrong. All values in the range are used.
User Profile Reset: No
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0
Confirmed. All values of the range are AND'ed and OR'ed.
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":
tdf#105562 Correct page for AND/OR logic function