Cells N$1,$ N$2,...,$ N$8$ are Numbers $($data$)$ and V$1,$ V$2,...,$ V$8$ are Decision variables. Also JRT is an $8$x$8$ joint risk table and is data.

Are these formulas linear or non$-$linear?

N

Floor$($V$1)+$ Floor$($V$2)$

The "partial" of stock $1($corresponding to V$1)$ in a portfolio determined by $($V$1,$ V$2,...,$ V$8),$ where JRT is the joint risk table.

SUMIF$($N$1$:N$4,$ V$8,$ V$1$:V$4)$

V$1/$ SUM$($N$1$:N$4)+$ V$2/$ SUM$($N$5$:N$8)$

COVARIANCE.P$($V$1$:V$4,$ V$5$:V$8)$

N$1^$V$1+$ N$2^$V$2$