The cell will get a list of symbols of elements, the melting temperature of below -200 degrees, or above 2000 degrees?
the first column is the name of the element and the second temperature
not asking you to do please suggest
asked March 19th 20 at 08:49
=QUERY(q!$E$3:$F$21, "select E where (F < -200) or (F > 2000)")
Find more questions by tags Google Sheets