[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Fwd: Forced Array Example
-------- Forwarded Message --------
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) 5A 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
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]