mxqrdq

Syntax:

Return Range  mxqrdq(Range matrix1)

Description:

Computes the orthogonal factor of matrix QR decomposition of matrix1 and places it at the current cell.

Examples:

($a4) = mxqrdq($a1:$c3)
Before:
AB CD
1147
2258
33620
4
5
6
After:
AB CD
1147
2258
33620
4-0.2672612419124240.87287156094397-0.408248290463863
5-0.5345224838248490.2182178902359920.816496580927726
6-0.801783725737273-0.436435780471985-0.408248290463863
($a2) = mxqrdq($a1:$d4)