I am trying to to use the Array formula that includes a minus and divide value. Here is my formula:-
I tried inserting MINUS( before the SUM but this didn't evaluate correctly. As far as the Divide goes I have tried to fit this in next to the MINUS, but this through up an error. I have read that minus and divide are not like by array formula but there is a workaround. could I ask for some help please in getting the above formula to operate as an array.
SUMfrom your equation, leaving everything else the same (including all sets of parentheses), and see if you get the result you expect.
$X$3), would you please edit the cell reference in your question formula for consistency. 2) There are many possible ways for this formula to be written (with and without
ARRAYFORMULA) would you please edit your spreadsheet to clearly include the answer that you are trying to calculate. 3) Column J includes a value in each row, would you please describe your expectations for the formula if there was not a value in each row.