I am referring to a cell in my spreadsheet that currently has no value
associated to it. I have a formula in the cell that refers back to another
cell. For example in cell F40 there is a calculation of =H40. In cell H40 I
have =G40*F39.

G40 and F39 are both blank. When I enter data into the spreadsheet these
cells will then be populated/calculate from the previously entered data.

Cell F39 is returning #VALUE. Is there a way for me to have this field
return a blank, if the value it's referring to is zero or blank?