Answer the question
In order to leave comments, you need to log in
How to make formulas for google docs table?
Hello, please tell me the formula. There is a cell A1 in which there is a value X (the value X implies the maximum value according to the condition of the problem) and it is necessary that all subsequent values in line No. 1 (A2-A3-A4, etc. conditionally ad infinitum) be summed up and subtracted from the value X in cell A1. The number of cells in a row is not known in advance, so it would be convenient to fill the range to infinity if possible, or to check if the cell in the row is automatically filled and only then take it into account. Can you please tell me if this task is possible?
Answer the question
In order to leave comments, you need to log in
In order for all subsequent values to be summed and subtracted, they must be summed and subtracted. Obviously. That is, in A1 it should be something like this:
=X-SUM(A2:A99)
Instead of X - the desired numerical value.
To be honest, the question is not well formulated. It is better to formulate on a fresh head if the head does not cook in the evening. For example, what is the maximum value? Maximum of what? Or let's say A2-A3-A4 etc. is not a row, but a column. Further, summing and subtracting can be done in different ways. If you said what to subtract from what and what to add with what, then this could be understood, but your cells are simply "subtracted" and "summed up", that is, as if by themselves.
In general, if abstract words are tight, then it is better to give a good example.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question