mxqrdr

Syntax:

Return Range  mxqrdr(Range matrix1)

Description:

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

Examples:

($a4) = mxqrdr($a1:$c3)
Before:
AB CD
1147
2258
33620
4
5
6
After:
AB CD
1147
2258
33620
4-3.74165738677394-8.55235974119758-22.1826830787312
501.96396101212393-0.872871560943962
600-4.49073119510249
($a2) = mxqrdr($a1:$d4)