delete cell content if it's "#n/a"

The macro has this formula:

Range("E2").FormulaR1C1 = "=if(RC[-2]=""cad"",RC[-3],RC[-3]/vlookup(RC[-2],fx_1,3,0))"

and the result the cell below the last row of the column returns N/A an I have manually delete its contents....

I've tried this code to make it automated, but it doesn't work..

For count = Range("E" & Rows.count).End(xlUp).Row To 1 Step -1
If Range("E" & count) = "#N/A" Then Rows(count).Delete

Any ideas?

Try if Range("E" & count).text = "#N/A"

the value of the cell will be an error but the text should be the #N/A.