Array Formulas Syntax - Matrix Calculations

Copper Contributor

Hi All,

 

I am trying to simplify the equation below to a single-cell formula, where a, b, c are constants, and d and T are independent variables I want to take as input (i.e. d is for density and T is for temperature).

The problem is I can not specify the T and d vectors, I must write them down in separate cells. What I would like, is to find a syntax to specify them in a formula, something of the like (F2^2;F2;1) and (G2^2;G2;1), in order to use with MMULT function.

Is there a way to do it?

Many thanks!!

clipboard_image_0.png

clipboard_image_1.png

0 Replies