Here is sample code for you to convert and calculate missing data without error messages:
"NaN" is short for Not a Number, which encapsulates how you would like to express lack of a number. I chose blank, you could use "Unavailable" or "?", etc.
Finally, here is how to code a multi-parameter formula with garbage filters:
