I
I
Ivan Melnikov2020-07-21 18:06:01
excel
Ivan Melnikov, 2020-07-21 18:06:01

Is it possible in Excel to somehow assemble a chain of formulas into one quickly?

For example, there is a formula in a cell, the argument of which is another cell, and there is another formula in it, etc. Such a chain of formulas can be quite long. Is it possible to somehow quickly assemble such a chain of formulas into one not with pens, but with a couple of clicks?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexey, 2020-07-21
@DramokL

Good afternoon!
I did it with crutches a long time ago - I inserted the sign ' [apostrophe] before each formula. Then the formula will be visible as text in the cell. I copy all the cells in Word, combine them as necessary and copy them back into one Excel cell.

B
BasiC2k, 2020-07-21
@BasiC2k

You can make a macro that will produce a similar assembly.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question