Hey all, wasn’t sure how to word this so allow me to clarify…
let’s say I have 4 cells e.g A1, A2, A3 & A4.
In cell A1 I have a number e.g 10.
I want to have the number 10 in the cell, plus a formula to the effect of -SUM(A2:A4) (10, minus the sum of cells A2:A4 ).
Let’s say cells A2-4 each contain the number 1; the result in cell A1 after entering the formula should be 7 (10 minus the sum of cells A2:A4 (3) = 7).
How do I make the number 10 coexist with the formula in the same cell? What would the formula look like in this case?
Thanks.
EDIT: It seems as if Lupp has got this question covered, and although I have found a way around the issue I was having, I feel that for the sake of discussion I should upload an example document to make the purposes of my question and the question itself more clear:
Example for Robleyd.ods