1. =VLOOKUP() #Excel
  2. =ifs(DAYS(TODAY(),Q8)>=730,0,DAYS(TODAY(),Q8)>=365,0.3%)
  3. =IMPORTXML(url, xpath) #Google Sheet
  4. =GOOGLEFINANCE() #Google Sheet
  5. =STOCK(NDQ.US.0) #Tecent Sheet
  6. =SUMIF(range, criteria, [sum_range])