How to remove NA from Calculation



I am currently using the formula below to get a percentage complete calculation, one of the parameters has the option for NA. How do I include the NA in the formula to make it so it doesn't affect the percentage? It is the bolded parameter below:

=SUM(IF([Paperwork Received]1 = "YES", 0.2, 0), IF([Samples Received]1 = "YES", 0.2, 0), IF([MEC HPLC Received]1 = "YES", 0.2, 0), IF(Hold1 = "YES", 0, 0), IF([Micro Received]1 = "YES", 0.2, 0), IF(Discrepancies1 = "NO", 0.2, 0))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!