Array formulas support the use of arithmetic operators “+”, “-”, “*”, “/”, “^”:
–For element-wise operations. Example: A1:A3 + B1:B3 → {A1+B1; A2+B2; A3+B3}.
–For operations between an array and a scalar. Example: A1:A3 * 2 →{A1*2; A2*2; A3*2}.
–When combining with functions. Example: SUM(A1:A3 * B1:B3).