Conditions for formulas in Google Docs?

Question

Google Sheets

Good afternoon, I'm trying to deal with Google docs, please tell me using the IMPORTRANGE
formula. For example, I insert data from Column A
=IMPORTRANGE("LINK_TO_LIST,"Stock!A:A")
1) Is it possible to make the data be inserted only if the value is NOT equal to "0.00" ?
And a super hard task
2) Is it possible to make the data to be inserted only if the value is NOT equal to "0.00" AND Column "T" in the same line is empty ?

Answer 1

These tasks are both super easy once you get the hang of the IMPORTRANGE.
The easiest way is to create prepared data on the LINK_TO_LIST side and load the data from this sheet.
The second way is to load the data on a separate sheet through IMPORTRANGEand filter them already on the receiver side.
Both ways are easy to implement through the FILTER formula
The general principle is reflected here https://gist.github.com/oshliaer/45242e42d50a39b0a...