To get rid of N/A in cells you can
A) conditionally format the cells to hide N/A values (i.e. white text)
b) use an if statement to check for the error. =If(ISNA(YourEquation,"",YourEquation)
The second solution will replace the error with whatever you want, but it does have to evaluate the equation twice so it is less efficient.