How to put a formula in a drop down list?

M

Mr.2020-06-14 14:33:07

Google Sheets

Mr., 2020-06-14 14:33:07

Formula =D1-G1
https://docs.google.com/spreadsheets/d/1qY5hphCm3b...

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

G

Grigory Boev, 2020-06-14
@ProgrammerForever

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

Similar questions

E

Evgeny Savitsky2018-09-28 00:25:56

Google spreadsheet (Excel) - how to make statistics on the contents of a column? 1Reply

V

vladislavik952021-12-06 15:23:44

How to make a randomness formula? 2Reply

C

ColdColt2020-08-24 14:43:15

How to transfer geodata from one table to another by entering only the label name? 1Reply

C

cyberlain2021-12-10 09:59:12

How to generate a hash of a string in a cell in Google Sheets? 1Reply

E

ekaterina37852020-08-27 00:57:16

How to write an array of data in a formula? 1Reply

Didn't find what you were looking for?

Ask your question