How do I hide the #DIV/0! error while a referenced cell is blank?

Question

In Column C I have Production. In column D I have Goal. In Column E I have variance %. My formula is `=(D11-C11)/D11`However, how do you hide the cells down the sheet until you put something in `D11` & `C11` to hide `#DIV/0!`. I have tried using the `IF` formula but seem to get it wrong?

Answer 1

you can also try iferror

=IFERROR(D11-C11)/D11," ")

Answer 2

If statement will do the trick

=IF(D11=0,"N/A",(D11-C11)/D11)

You can just blank the cell with " " instead of "N/A"