Vector and Matrix - Rotation3D
Rotation3D is an array function. Select the 3 by 3 block of cells to which you want to add the formula and type the formula in the formula box. Then press Ctrl-Shift-Enter.
The rotation matrix can be used to rotate any set of x,y,z coordinates by multiplying it with the rotation matrix. Consider a point A in 3D space with coordinates x, y and z. The vector OA (from the origin to A) can be rotated by multiplying it by the rotation matrix. Suppose the rotation matrix is in A1:C3 and the coordinates of A are in E1:G1 then the formula =MMult(E1:G1,A1:C3) will rotate the x,y,z coordinates of A to x',b',c', the coordinates of A', the point after the rotation was done.