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
March 19th 20 at 08:49
1 answer
March 19th 20 at 08:51
Solution
=QUERY(q!$E$3:$F$21, "select E where (F < -200) or (F > 2000)")
=QUERY(q!$A:$B; < - dot comma - Thelma_Bergstrom commented on March 19th 20 at 08:54

Find more questions by tags Google Sheets