Forum Discussion
Is there a function to multiple same row of two tables? MMULT does not
Is there a function to multiple cell for cell of two Tables? Otherwise, to use MMULT, my understanding is I need to transpose; if so, wouldn't date information across a row of columns become unconven...
To multiply each deposit by the corresponding exchange rate would require a straightforward multiplication.
= rates * depositsTo sum the amounts held in each currency, you could use MMULT
= MMULT(rates * deposits, {1;1;1})or you could use a 365 helper function to sum across rows
= BYROW(rates * deposits, LAMBDA(x, SUM(x)))In the near future this last formula will reduce to
= BYROW(rates * deposits, SUM)which is somewhat less intimidating.