forgot #N/A has special rules -
reading here if your interested


change code to 

    If Cells(rownum, 16) = CVErr(2042) Then
        Cells(rownum, 16) = "NOT INDICATED"
    End If
        
    If Cells(rownum, 17) = CVErr(2042) Then
        Cells(rownum, 17) = "NOT INDICATED"
    End If