Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =sumif(A1:A20,"<>0")
- =if(isna(googlefinance("DoesNotExist"; "price"),"NA returned",googlefinance("DoesNotExist"; "price")))
- ColA
- CCLXXX
- =googlefinance(A1; "price")
- =if(isna(A2,"Not avail",A2))
- =if(isna(A1),0,A1)
- =ArrayFormula(max(if(not(iserror(A:A)),A:A)))
- =sumif(A1:A20,"<>#N/A")
Add Comment
Please, Sign In to add comment