Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
S
S
sheet2019-03-27 13:34:41
Google Sheets
sheet, 2019-03-27 13:34:41

In a cell, get a list of symbols for elements whose melting point is below -200 degrees, or above 2000 degrees?

the first column is the name of the element and the second temperature
is not asked to do, please tell me

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
S
sheet, 2019-03-27
@sheet

=QUERY(q!$E$3:$F$21, "select E where (F < -200) or (F > 2000)")

Similar questions
Y
Yaros752020-12-06 15:30:38
How to execute a formula in GOOGLE SHEETS notation, assembled from text fragments, using a user-defined function? 1Reply
A
andriy71122019-03-24 17:47:08
How can I catch updating / changing cells in a Google spreadsheet? 1Reply
G
gladyshef2019-03-29 16:10:00
How to calculate the number of payments on different days automatically and multiply by the rule by the reward? 0Reply
M
Max2019-04-02 14:28:00
How to get the exchange rate for a specified date through GoogleFinance? 1Reply
A
Alex Quban2019-04-03 09:03:19
How to avoid skipping rows when updating data in a table? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question