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;
}