Validate Query

Provides an alternative to #N/A from a query result eg;
=validate(GoogleFinance(“LON:AFHD”,”price”),”-“)
Returns a – instead of #N/A

The code to this function is as follows:

function validate(query, fix) {
if (query==”#N/A”){return fix;}
return query;
}

 

Comments are closed.