Question: how to make a long formula in excel?
Answer: Click the cell where you want the formula result to appear (F11, for example).
Type the equals sign (=).
Type an open parenthesis, then click the cell that contains the first value you want in the formula (F4, for example).