QuickTrick: Remove Unwanted #NAs From Spreadsheets

Problem

The #NA is not inherently harmful and it disappears as soon as the cell formula has the information needed to fulfill its mission. There may actually be some situations where you want to see the #NA to prompt you to…