-------- Forwarded Message -------- Subject: Forced Array Example Date: Sun, 3 Dec 2017 17:45:12 -0500 From: Patrick Durusau <
patrick@durusau.net> To: ODF TC List <
office@lists.oasis-open.org> Greetings! To follow up on our discussion last week of
https://issues.oasis-open.org/browse/OFFICE-3905 LINEST and LOGEST and Force Array. Visit:
https://help.libreoffice.org/Calc/Array_Functions Look for: Conditional Array Calculations, which has this example: A 1 B (formula) =A1:A2+1 B (result) 2 C (forced array formula) =SUMPRODUCT(A1:A2+1) C (result) 5 A 2 B (formula) =A1:A2+1 B (result) 3 C (forced array formula) =SUMPRODUCT(A1:A2+1) C (result) 5 MS Excel example:
https://www.techonthenet.com/excel/formulas/sumproduct.php Latest office product help:
https://support.office.com/en-us/article/SUMPRODUCT-function-16753e75-9f68-4874-94ac-4d2145a2fd2e Does that help? Jos? Hope everyone is at the start of a great week! Patrick PS: I will test it tonight but all I need to do in the short term to fix my phone issues is to run a VM that then runs Skype, ahem, on a different OS. ;-) -- Patrick Durusau
patrick@durusau.net Technical Advisory Board, OASIS (TAB) Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300 Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps) Another Word For It (blog):
http://tm.durusau.net Homepage:
http://www.durusau.net Twitter: patrickDurusau Attachment: signature.asc Description: OpenPGP digital signature