Fwd: Forced Array Example

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. ;-)