Answer the question
In order to leave comments, you need to log in
Is it possible to make a drop down list with this formula?
I have formula
=A1-S2in every line. I want to make the formula appear on click.
Answer the question
In order to leave comments, you need to log in
Right click on a cell: Data Validation .
Rules: Values from the list
and write all your options there, separated by commas, for example:
=C1-B1,=C2-B2,=C3-B3
Demo table
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question